Automic Continuous Delivery Automation

  • Private Community
Back to discussions
Expand all | Collapse all

Table name or Query needed to fetch the data through STATISTICS window

  • 1.  Table name or Query needed to fetch the data through STATISTICS window

    Posted Jun 07, 2018 10:49 AM

    Does anyone had a requirement of creating a SQL query to fetch data from uc4 database for analyzing the statistics of workflows and jobs for eg. runtime, status, start time, runtime.

    Or if anyone knows the table where I can fetch the information which I am able to see through STATISTICS window in UC4.



  • 2.  Re: Table name or Query needed to fetch the data through STATISTICS window

    Posted Jun 08, 2018 04:25 PM

    I would start with the AH table.

     

    DB schema for reference:

     

    AE Database (11.2 (Step 018))