System Center Orchestrator SQL Query–Query failed Runbooks » TechGuy
For your routine Orchestrator Checks, it can be vefy useful to see all failed Runbooks in a period. Of course you can go to each Runbook, and check the Logs, but to be honest, this is not fun. So, there is a SQL Query to help on this.