Hi John,
There isn’t a script to trigger the Controls Catalog Report; however, you can use the SQL below to achieve the same output as the report. Note that we don’t generally recommend tapping into the database directly since the structure may change release by release, but this would provide a solution to your needs.
SELECT PROCESSGROUP.NAME AS "Control Entity", PROCESSDEFINITION.DISPLAYNAME AS "Control Point", PERIODYYYYMM, EXECUTIONCOUNT
FROM PROCESSCOUNTS
INNER JOIN PROCESSCOUNTPD ON PROCESSCOUNTPDPK=PROCESSCOUNTPDFK
INNER JOIN PROCESSDEFINITION ON PROCESSDEFINITIONFK=PROCESSDEFINITIONPK
INNER JOIN PROCESSGROUP ON PROCESSGROUPFK=PROCESSGROUPPK
WHERE PROCESSGROUPFK>1
ORDER BY PERIODYYYYMM DESC
It’s also possible to achieve the same goal via Data360 DQ+. Assure sends execution results to DQ+ for the purpose of custom reports and dashboards. More details on this is in the “Control Execution Results to Data360 DQ+” section of the Assure 9.3 Release Notes.