There's more to experience when you log in!
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!
As the table structure may change with each release, it is best to avoid direct queries which tap into the database in this manner. This may be why you are seeing inconsistencies between the report and query mentioned.
Browsing around, I believe the following community post and related article may be of assistance :
Run Controls Catalog Report
How to view control execution time in Assure UI and in Assure Database