Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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