SQL workflow and its task history

[Benedikt Weiler]

Hi guys,

could someone tell me the tables to find start time, running time, end time of a workflow and its tasks/steps?
I need the history -> for example last 60 days.

Workflow A
    STEP 1
    STEP 2
    STEP 3

Workflow B
    STEP 1
    STEP 2
    STEP 3


Thanks a lot 

regards,
Ben

[Pete Wirfs]

AH table.  One row for each runid.  ah_idnr is runid.  I suspect column ah_parentact probably binds tasks to workflows(?)

The product also has a reporting utility that does a nice job too, but I doubt it will relate tasks to workflows.  It can extract the results into either HTML or CSV format.  
https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Utilities/admin_AEDBReportingTool_About.htm%3FTocPath%3DReference%7CUtilities%7C_____6

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Pete Wirfs]

column descriptions;
https://docs.automic.com/documentation/WEBHELP/English/all/components/AE/latest/DB%20Schema/db/_structure/HTML/index.htm

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------