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. Put the Name of the Runbook in the Query, […]
Get Runbook Queue Count – System Center Orchestrator Read More »
As some of you may know, I was speaking at Experts Live 2019 in Prague, a few weeks ago. Experts Live Europe is the biggest, Microsoft Community Event in Europe, and it was a honor to be part of it, as a speaker. On the first Day of the Main Conference, I was speaking about
This was Experts Live Europe 2019 Read More »
Hi, as you may noticed, i have been at CDC Germany in Hanau a few weeks ago, talking about Service Management and Automation. The Session has been recorded an is available now (German) If the Preview is not working, you can click on that URL: https://vimeo.com/341831252/ff1f56351e
System Center SCSM und SCO Session from CDCGermany Read More »
Hi, some exciting weeks and month are coming up, some Speaker Engagements, Meetups or Sponsor Slots are around. So if you like to meet, feel free to visit and talk to me. Speaker System Center User Group Munich – 17. April 2019 – Microsoft München – Phönix aus der Asche – Service Management und Automatisierung
Upcoming Speaker Engagements, Meetups or other Appointments Read More »
Since a few days, System Center 2019 is GA, so lets upgrade our environment to the latest bits. I will start with System Center 2019 Orchestrator. Very important note here, System C So lets start with a quick overview on what’s new. What’s new with SCO 2019 Support for PowerShell 4.0+ Support for SQL 2017
Upgrade to System Center Orchestrator 2019 Read More »
In the most cases, the Reporting has to be done through the Data warehouse DB for SCSM, but in some cases you have to get all the Data from the ServiceManager DB. For Example if you don’t have a Data warehouse DB for SCSM or you need some more Details. In this Case you have
System Center Service Manager–SQL Query to get a full List of your Incidents Read More »
In some cases it can happen that the Log Purge is not working anymore, or not working correctly. In a real bad situation it can happen, that the daily Log Purge will make more troubles, maybe stops your Runbooks from working. Than you will see a lot of orphaned Runbooks, and in the most cases
System Center Orchestrator–SQL Query detailed Logs and behind the Scene Read More »
To keep System Center Orchestrator up and running, and of course healthy, you need to take care of orphaned Runbooks. Sometime, or maybe more often, Orchestrator produces orphaned Runbooks. As you maybe know, Orchestrator acts very special with his Database, so always make sure the Database is attached as best as possible. What are orphaned
Check and remove orphaned Runbooks Read More »
It is very important to take care of your System Center Orchestrator Environment. I have introduced multiple ways to do this, bit one very important one is the Free Tool called, Orchestrator Health Checker. This tool is providing you a lot of options to control and monitor your Orchestrator Environment. First, you have to download
System Center Orchestrator Health Checker Read More »
For your routine Orchestrator Checks, it can be vefy useful to see all failed Runbooks in a period. Of course you can go to each Runbook, and check the Logs, but to be honest, this is not fun. So, there is a SQL Query to help on this. At the end of the the Query,
System Center Orchestrator SQL Query–Query failed Runbooks Read More »
