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 by more than one Parent Runbook.

For Example, you build a Runbook to add a User in a Group. This Runbook will definitely be used by different Parent Runbooks. And in this case, it can sometimes be useful to query all Runbooks, which are calling our “Add User to Group” Runbook.

So, without any longer explanation, here is the SQL Query, which need to be run against the Orchestrator DB.

Don’t forget to change the Name of the Runbook, you want to query, at the End of the Script, in our example the name is “1.1-AddUserToGroup”

(Read more…)

My First Book, SCO 2016 Cookbook

19983349_10213512180022234_3764719510414147102_oHi all, I am feeling really proud, cause my first book has been published a few days ago.

A few months ago, the guys from PacktPublishing asked me to write the System Center 2016 Orchestrator Cookbook. It took not too long to make a decision and this was positive.

So I have decided not only to write an update, I have done a complete makeover of this book.

I have added a lot of new Recipes and have added a lot of my experience from the past 6 years. In the End, we have a complete new book, so go ahead and get your copy.

Don’t forget to write a Review on Amazon.


Michael Seidl aka Techguy