System Center Orchestrator

How to Cancel All Orchestrator jobs with SQL

When automated systems go wrong you may need to cancel a backlog of pending or running Orchestrator jobs directly with SQL.

For reference, the StatusId field from Orchestrator’s Job table provides the current status of the job.  These numeric represent:

0 = Pending

1 = Running

2 = Failed

3 = Cancelled

4 = Completed

The script may be run directly with SQL Management Studio.

Calling Orchestrator Runbooks (& retrieving output) via REST

This example uses PowerShell to call an Orchestrator runbook and display the results.

To demonstrate the scripting, I have created a simple runbook that will accept a string input.  It’s titled “Input1”.

Using XML Lookup Files with Orchestrator

There can be many reasons for needing site specific data related to an IP address.  I had a recent requirement for Orchestrator to configure machines when the only input was the IP Address of the target machine.   This solution uses PowerShell to compare an IP Address to an XML based lookup table of site information.  By finding the right site, other locale details can be used through Orchestrator.  The XML below represents the site information needed by my particular process.

Automating the Linux SCCM Client install with Orchestrator

Orchestrator can be used to automate the installation of SCCM on template deployed Linux machines.  Microsoft’s growing support for Linux platforms allows SCCM to be used for centralised reporting while opening the door for SCCM to become a unified platform deployment system at some stage in the future.

Orchestrator - Run SSH fails with hardened Linux Machines

System Center Orchestrator has a built in activity for running SSH on remote machines.  You may find that working runbooks start failing on new distributions of linux or with hardened machines.

Orchestrator’s ssh is simply calling the command-line version of putty (called plink) from the C drive of the Runbook Server.  The executable is located in:

Listing SCCM 2012 R2 Applications with Orchestrator

As Orchestrator is guaranteed to grow in importance for most Microsoft based organisations, the need to query the Configuration Manager database becomes more important as well. 

SCCM 2012 R2 Admin Console crashes with Orchestrator SCCM 2012 R2 Integration

The Integration Pack for System Center 2012 Configuration Manager, distributed via Orchestrator, causes the loading of the SCCM admin console to crash on servers that have been distributed to.

Error specifics of the Admin Console crash are:

  Problem Event Name:                        CLR20r3

  Problem Signature 04:                       System

Subscribe to RSS - Orchestrator