Blog Archives

Useful Orchestrator SQL Queries

Just thought I’d post up some useful SQL queries that I use regularly in our environments! Web Service Authorization Cache –Refresh Authorization Cache Use Orchestrator   Truncate table [Microsoft.SystemCenter.Orchestrator.Internal].AuthorizationCache   DECLARE @secToken INT DECLARE tokenCursor CURSOR FOR   SELECT Id

Tagged with: , , ,
Posted in General Information

Runbook SQL Injection

With our implementation of Orchestrator 2012 we plan to fully implement and utilize the fancy new web tier – specifically we plan to expand our automation to include many more user initiated workflows.  This means that we will need to

Tagged with: , , , , ,
Posted in General Information, Integration Pack

Opalis DB SQL Queries

Here are some interesting SQL queries against the Opalis DB that I have come up with Policies Select runtime information about non deleted policies select * from POLICIES_VIEW where Deleted is null Select all currently running policies select * from

Tagged with: ,
Posted in General Information