Compliance History Query

[Former Member]

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?

[Former Member]

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

[Former Member]

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?

[Former Member]

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!

[Former Member]

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