Capture start time, end time and status of alteryx workflow and write to output file

[ujjawal2]

I have a requirement where basically a manual log has to be created for all workflows being run. I am able to capture the start time/ end time using formula tool after getting the input and before writing it to database through output tool. Is there a way to read the datetimenow() function in formula tool after the workflow has written to the database that is after the output tool has finished(since there is no flow after the output tool I don't understand how it can be achieved)? Also how can I get the status(success/failure) of the workflow run stored in the same output log file so that the final file has these fields - start time, end time and status.

[ChrisTX]

I found these posts helpful, when trying to capture and parse log files:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Catching-and-responding-to-errors-with...

https://community.alteryx.com/t5/Setup-Configuration/Log-File-Location-and-Variables/m-p/80884/highl...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Save-workflow-messages-log-in-database...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-export-messages-from-the-result...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-export-messages-from-the-result...

The IT group at a company needs to analyze Alteryx log files to track any errors occurring in workflows
https://community.alteryx.com/t5/Alteryx-Use-Cases/Analyze-Alteryx-Log-Files/ta-p/61742

Click here to download sample workflow:
https://community.alteryx.com/pvsmt99345/attachments/pvsmt99345/use-cases/153/3/Banking%20-%20Financ...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-Error-Log-for-Export/td-p/328...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-Error-Log-for-Export/m-p/3289...

Automatically create report of operations
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Automatically-create-report-of-operati...

Idea, with a few tips in the comment section:
Idea: Improve Log files for simpler parsing
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Improve-Log-files-for-simpler-parsing/idi-p/...

https://community.alteryx.com/t5/Alteryx-Designer/Reusing-reserved-variables-outside-Alteryx/td-p/18...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Capture-runtime-and-workflow-status/td...

Logging workflow metadata after run to Database
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Logging-workflow-metadata-after-run-to...

Chris