Assure DQ

 View Only

  • 1.  Question about Report Catalog - Infogix Assure

    Employee
    Posted 06-25-2021 09:40

    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!



  • 2.  RE: Question about Report Catalog - Infogix Assure

    Employee
    Posted 09-24-2021 08:28

    Hi Nicholas,

    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

    Matthew Kennedy