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

5 Comments / orchestrator, SCO, SQL, SYSCTR

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 this.


Select lower(POLICIES.UniqueID) as RunbookID, lower(CUSTOM_START_PARAMETERS.UniqueID) as ParameterID, CUSTOM_START_PARAMETERS.value
From POLICIES
INNER JOIN OBJECTS  on POLICIES.UniqueID = OBJECTS.ParentID
LEFT OUTER JOIN CUSTOM_START_PARAMETERS on OBJECTS.UniqueID = CUSTOM_START_PARAMETERS.ParentID
Where POLICIES.Name ='Your Runbook Name' and policies.deleted = 0

Put the Name of the Runbook in the Query.

The result should look like this

Michael Seidl, aka Techguy
au2mate, everything

  1. 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. In a...
  2. 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...
  3. 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,...
  4. 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...
  5. 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...

5 thoughts on “SQL Query to get Runbook and Parameter ID from SQL – System Center Orchestrator”

  1. Pingback: PowerShell Script to trigger Orchestrator Runbook - TechGuy

  4. Sam

    Running SCORCH 2022 and get this error when trying your query. Suggestions? Msg 208, Level 16, State 1, Line 1
    Invalid object name ‘POLICIES’.

Leave a Comment

Your email address will not be published. Required fields are marked *

CAPTCHA

*