This is my contribution on how you can create an Orchestrator database to store information when running the Runbook.
This is how a Runbook could look like when adding log to the database.
Every “Write to Log” is adding information into the database with an INSERT clause. I use three different status messages depending on what is happening in the Runbook. The three different status messages I am using is: Success, Failed and Done.
This database is also perfect for reporting on how many Runbooks have been ran during a certain period.
Creating the database file: CreateOrchestratorDB