Get Runbook Queue Count – System Center Orchestrator

Leave a Comment / SCO, SYSCTR

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

  1. 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,...
  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 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...
  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. 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...

Leave a Comment

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

CAPTCHA

*