BLOGOTHEK // Die aktuellsten Beiträge und Artikel der Österreichischen Blogs

Orchestrator SQL Query to query a specific String in .Net Acticity

System Center Orchestrator is an excellent Workflow Engine to run and trigger PowerShell Code. Additionally, SCO provides a way to store Credentials, Server Names, and other recording Values in global Variables. So if a Server Name Changes or Azure App...

Change SCSM Report Server URL to HTTPS

Recently I had to change the SCSM Report Server URL from Port 80 (HTTP) to Port 443 (HTTPS) in an existing Environment. The summary is yers short, change Report Server Config and then change a Value in DWH SQL Database, but do find the correct Value in...

Speed up SCSM and SCO Workflows

This is a short post on how to speed up SCSM on how Orchestrator Runbook Activities are processed much faster. when you create a Service Request or other Activities with Runbook Activities, it often takes a lot of time until the Runbook is triggered an...

PowerShell Script to trigger Orchestrator Runbook

From time to time, I need to Trigger an Orchestrator Runbook via PowerShell and the WebService SCO offers. So I will walk you through all the steps, from creating the Runbook with Initialize Data, assigning the needed Permission, and writing the PowerS...

SQL Query to get Runbook and Parameter ID from SQL – System Center Orchestrator

This will be a short post, but I often need the SQL Query to get the Runbook ID and the Parameter ID from a specific Runbook in System Center Orchestrator. So, as I always look on the Internet, I decided to write this post for you and me when I need th...

Remove duplicate Managers from SCSM User

Recently we used the “Line Manager Should Review” Option in SCSM Review Activities the First Time with a Customer. We quickly ran into a problem that the Manager could not be gathered with this error. “Cannot identify line manager of&...

Backup and Restore Last Modified Date for SCSM Change Requests

This is a classic Post cause it is related to System Center Service Manager. I am still doing a lot of Service Manager Staff, and now I start again talking about. When you import a Management Pack related to the Service Request Class, the Last Modified...

Migrate Orchestrator Server in an SCSM Environment

This Article will show, how to migrate a System Center Orchestrator Server to a new Machine, when connected to a System Center Service Manager Server. So the Challenge is. To keep the Runbook ID and change the Orchestrator SCSM Connector to the new URL...

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