1 of 1 people found this helpful
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?
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?
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!
The secondary query needs to be set to run automatically, creating a Compliance Event