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
1 thought on “SQL Query to get Runbook and Parameter ID from SQL – System Center Orchestrator”
Pingback: PowerShell Script to trigger Orchestrator Runbook - TechGuy