cancel
Showing results for 
Search instead for 
Did you mean: 
Dogers
Level 7
Report Inappropriate Content
Message 1 of 5

Compliance History Query

We've got ePO 4.5 and the individual queries "McAfee Agent and VirusScan Enterprise (for Windows) Compliance Summary" and "ePO Compliance History" work fine, but we've duplicated them and made some changes to better suit how we want them to appear. The issue we're having is that in the duplicated Compliance History query, we cannot choose our newly duplicated Summary query at the filter stage. The list of queries which appear there appears to be preset from somewhere - how do we add to this?

Labels (1)
4 Replies

Re: Compliance History Query

Dear Dogers,

is it possible to obtain a screenshot of which queries you get displayed when tying to choose within the "ePO Compliance History" filter?

It seems that the values in the filter option are gathered from the ePO 4.5 table called [dbo].[EPOComplianceHistoryProperties] can you verify that the same queries exist in this table?

Many thanks,

Rene

Dogers
Level 7
Report Inappropriate Content
Message 3 of 5

Re: Compliance History Query

Hi Rene

This is what we get - http://imgur.com/dxBwd.jpg

The queries listed here are indeed in that table. From poking around some more, I'm guessing then that we need to update the server task which runs those reports to include our new one? Presumably that would add it in to this table and allow it to be selected?

Dogers
Level 7
Report Inappropriate Content
Message 4 of 5

Re: Compliance History Query

It seems I am correct! We've expanded the default "VSE: Compliance Over the Last 30 Days" to run our modified report also. After a manual run, it now appears in the list, so we've set up the other query to use that and all is well

Thanks for the pointers!

Dogers
Level 7
Report Inappropriate Content
Message 5 of 5

Re: Compliance History Query

The secondary query needs to be set to run automatically, creating a Compliance Event