Hi
are you talking from the Workflows that are
currently blocked?
Otherwise you won't get much output because the Stati of a workflow during execution are not logged by default.
Example:
Workflow starts at 07:00
at 07:10 a job fails, WF gets blocked
at 07:25 ops staff restarts the job, WF continues running
07:30 WF is done, Status ENDED ok
after 07:30
If you check the WF status its ENDED_OK
You will see the status "BLOCKED" only between 07:10 and 07:25 when the WF is blocked.
In addition to that The Block state is a state of the workflow that a failed job could lead to but does not necessarily lead to - depending on the WF setting (dependencies).
So your request is kind of tricky and not easy to fulfill.
=> I personally would use an SQL of all Jobs that did not end ENDED_OK and collect their parent if its a Workflow. Its not 100% your request but I think quite close to it :-)
cheers, Wolfgang
------------------------------
Support Info:
if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
Otherwise update/upgrade your system and check if the problem still exists.
------------------------------
Original Message:
Sent: 01-08-2020 06:48 AM
From: Akcaoglu
Subject: Send status of the workflows via email
Hi ALL,
i want to send daily the status of the "blocked" workflows via email.
i have try it with the AE DB Reporting Tool and revision report but i get only a list with "ended" workflows.
How can i get or read the information like object name, title, start time, end time and runtime of the blocked jobs?
Maybe with SQL? Do you have any idea?
Thanks in advance.
Best regards
Salih