Process Execution Report with duration stats (using WA database)
Hi, I would like to share with you a report that I've developed for my own purposes. It is based on data from the WinAutomation internal databases and shows the status of the last executions of processes, counts the duration of their execution and notifies about detected problems by email.
You can use it in whole or use any of its components separately for your needs (for example, accessing a WinAutomation database or combining data from different Excel tabs).
Brief description of the process:
- Runs daily (the schedule will need to be created manually) and tracks the result of the processes execution in the last 24 hours
- Receives data from the process database and logs database
- Writes received the data in Excel
- Joins the received data and calculates the execution durations
- Counts the number of errors and generates an email message with a list of processes fails and errors (separately for fail and error, where fail – if the process had to start but did not start*, and error – if the process started, but completed with an error)
- Sends a nice email notification with details in excel-report attached
*All my scheduled processes run daily, so the determination of the need to run is perfomed by the mere presence of a schedule. If it is necessary to control the processes that are launched less frequently – a little refinement is needed.
Before using, you will need to:
- Install drivers for SQLite: http://www.ch-werner.de/sqliteodbc/
- Point %Main_ReportFile% variable on RPA Report.xlsx
- Set other needed variables, see the comments inside WAJ