Hello,
In previous versions of Assure the report for executions was not available, and we were provided with a query to run which would count the executions (see below). I am trying to identify how the control catalog report works, and why there is a difference in numbers between the below query and the report. Also, is there a way to automate this report through a script or querying the DB directly?
select * from auditedevent where timeoccured >= :FirstDayOfMonth and timeoccured < :LastDayOfMonth
Thank you for any help!