List of successful workflow executions

[LAR1985]

Hello community,

I need to obtain a list of workflows that have been successfully executed in a month. Do you know if there is a way to do this?

I am using the workflowlog table, extracting the records that contain the text ‘workflow is being run’ to obtain those that have been executed, but I cannot find a way to exclude those that ended in error since I cannot find an execution ID, and if a workflow has been executed several times during the day, I cannot differentiate which execution the error belongs to in the workflowlog table..

Thanks

[ccg1706 · Accepted solution]

Hi @LAR1985, 

Try to filter using @status field, that way you can exclude the ones that have errors or paused. Also a more detailed way could be via workflow schema (xtk:workflow), @processDate attribute gathers the value of the workflows last executed date time and @nextProcessingDate atribute collects the value of the workflow next execution date time.

I attach you official documentation for guidance: Monitoring workflow execution 

If you need more help just let me know. 

Best, 

Celia