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

SELECT COUNT(*)
FROM POLICY_PUBLISH_QUEUE Q
inner join POLICIES_VIEW as v on Q.PolicyID=v.UniqueID
 where v.Name = 'Your Runbook Name'

Put the Name of the Runbook in the Query, and get the actual Queue Count.

Michael Seidl aka Techguy

Leave a Comment

Your email address will not be published.

*

%d bloggers like this: