BLOGOTHEK // Die aktuellsten Beiträge und Artikel der Österreichischen Blogs

PowerShell Script to trigger Orchestrator Runbook

From time to time, I need to Trigger an Orchestrator Runbook via PowerShell and the WebService SCO offers. So I will walk you through all the steps, from creating the Runbook with Initialize Data, assigning the needed Permission, and writing the PowerS...

SQL Query to get Runbook and Parameter ID from SQL – System Center Orchestrator

This will be a short post, but I often need the SQL Query to get the Runbook ID and the Parameter ID from a specific Runbook in System Center Orchestrator. So, as I always look on the Internet, I decided to write this post for you and me when I need th...

Get Runbook Queue Count – System Center Orchestrator

This short post will give you an example to query a Runbook Queue Count. In some scenarios, it can help to get the actual Queue Count before triggering a Runbook. To Query the Queue, use the following SQL Query against your Orchestrator SQL Server and ...

System Center Orchestrator–SQL Query detailed Logs and behind the Scene

In some cases it can happen that the Log Purge is not working anymore, or not working correctly.

Check and remove orphaned Runbooks

To keep System Center Orchestrator up and running, and of course healthy, you need to take care of orphaned Runbooks. Sometime, or maybe more often, Orchestrator produces orphaned Runbooks.

System Center Orchestrator SQL Query–Query failed Runbooks

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.

System Center Orchestrator SQL Query–Get Parent Caller Runbook

In huge System Center Orchestrator Environments, it is usual to make a lot of Sub Runbooks, that will be called by more than one Parent Runbook. For Example, you build a Runbook to add a User in a Group. This Runbook will definitely be used by differen...

System Center Orchestrator SQL Query–Runbook Run Count

This will be a short Post, sometimes it can be helpful to get a List of Runbooks and the Count, on how many times the Runbook has been executed. Maybe if you are looking for most executed Runbook in case of an Performance Issue or you just want to trac...

Orchestrator SQL Query to get Runbook running-time

Lately, we had a Requirement, at one of our Customers, to alert someone, if a Runbook is longer running than 30 minutes.