Get text from file in Linux system and add it to the Orchestrator databus

This Runbook copies everything inside a file on a Linux system and puts it on the databus. The text can then later be used in the Runbook and for example be copied to a text file.

In the example below the text in a Linux system text file will be copied to a text file.

Details on the Run SSH activity in Orchestrator.

Get text from file in Linux System 1

Details on the Append Line activity in Orchestrator.

Get text from file in Linux System 2

Execution Result is appended in the Text field at the Append Line activity.

Get text from file in Linux System 3


Alternative solution to add Locale on User Configuration Item in Service Manager 2012

The solution is provided “AS-IS” with no warranties and may not be supported by Microsoft.

This is an alternative solution to add Locale on User Configuration Items (CI) in System Center Service Manager 2012 (SCSM). It will use a System Center Orchestrator Runbook to add the locale for the user SCSM CI.

The Runbook needs two kinds of input. One is the SamAccountName and the other one is the locale. This typical Runbook only sets sv-SE, if provided as an input, or en-US for all other kind of locale input. The Runbook can easily be modified to set other locale by extending the Runbook.


To be able to use this Runbook you need to have the Service Manager Integration Pack installed in Orchestrator.

Please feel free to download the Runbook and try it out yourself!

Runbook download: SetLocale

Remove Client Push records in Configuration Manager 2012

The solution is provided “AS-IS” with no warranties and may not be supported by Microsoft.

This solution stops Client Push in Configuration Manager 2012.

Start off by reading this at TechNet “What’s New in Configuration Manager for Windows-Based Computers”.

“Client push installation starts and tracks the installation of the client by using the Configuration Manager database and no longer creates individual .CCR files. When you enable client push installation for a site, all discovered resources that are assigned to the site and that do not have a client installed are immediately added to the database, and client installation begins.”

 Another thing that is good to know is that the SCCM server will stop to push to clients after 7 days if it cannot contact the client computers on the network. But before that it will try to push to them every hour until it succeeds.

Removing Client Push in Database

It is never supported to make changes directly to the database so this solution is only for test purposes.

Looking at the table ”ClientPushMachine_G” in the ConfigMgr database you can see the records of the client push.


What happens if we delete them or the one that returns error with client push? I have tried this in my lab environment and it seems to stop the client push to the clients.

If you want to try this yourself do this

  1. Generate client push records by using the application “Generate CCR” that you can find in the folder Adminconsle\Bin\ClientPushGenerator.exe on the ConfigMgr server. Generate clients that do not exist on the network. This will cause the push to return error.

Create a txt-file with the computernames under each other. Ex:




 Load this file into the application.


 2.      Look in the database table ”ClientPushMachine_G” to see if the clients have been registered.


You can also look in the view “v_CP_Machine” to see the clients.

 3.      Delete the rows with the clients you don’t want to push to anymore and look in the ccm.log to see if the push to this clients ends.

DELETE FROM ClientPushMachine_G WHERE Name like ‘Client01’;

Alternative layout at the Configuration Manager 2012 Console

The solution is provided “AS-IS” with no warranties and may not be supported by Microsoft.

This solution will change the layout of the ConfigMgr console? It could be that you wanted to move a node at the left menu or build your own layout of the whole console. Now this is easy to do with the tool “SCCM Console Builder”.

Before doing any of this changes, please backup your configuration files.

To start editing your SCCM Console, go to your console installation directory and browse to “AdminConsole\Bin”. Launch “AdminUI.ConsoleBuilder.exe” and click File, Open and then ConnectedConsole. This will load the XML file “C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\XMLStorage\ConsoleRoot\ConnectedConsole.xml”

Now you can for example go to the Administration Node on the left button and then, for example, remove the “Distribution Point Migration” by choosing delete.


Wait some time and then launch the Configuration Manager Console. This should be the result.


You could also move things around and do something like this.


The result will be.