Importing data into SCSM (part3) – the SCSM OpsMgr CI connector

December 2, 2009 at 10:06 pm in Uncategorized by kurtvh

As specified in previous blog, two OpsMgr connectors are available in Service Manager:

  • Operations Manager Alert connector: The OpsMgr alert connector is used to automatically generate incidents that are based on Operations Manager alerts.
  • Operations Manager CI connector: This connector will import objects that were discovered by Operations Manager into the Service Manager database. (For example, distributed apps or SQL databases.)

This blog will handle the Operations Manager CI Connector.

There are two steps that need to be followed for the installation of the OpsMgr CI connector:

  • Import of the management packs: In order to import objects discovered in Operations Manager, Service Manager will need a list of class definitions for these objects that we can obtain from the Operations Manager management packs.
  • Installation of the OpsMgr CI connector in SCSM: The actual installation and configuration of the connector in the SCSM mgmt console.

Import the management packs

Download the file InstallOMMPs.exe from the Connect Web site

1. On the SCSM server, create a folder for the file InstallOMMPs.exe. (for example D:\MP)

2. Double-click InstallOMMPs.exe to extract the files.

3. In the Unzip to folder field, type the location of the folder that you created in step 1, and then click Unzip. (D:\MP)

4. On the Windows desktop, click Start, click Programs, click Windows PowerShell 1.0, right-click Windows PowerShell, and then click Run as administrator.

5. Change directories to folder you created in step 1, and then click ENTER. (D:\MP)

6. In the Windows PowerShell window, run the following commands:

1. set-ExecutionPolicy unrestricted

2. .\installOMMPs.ps1


1. Type exit and then press ENTER.

If you have installed additional management packs in Operations Manager and you want to add the data from those additional management packs to Service Manager, you can edit the Operations Manager CI Connector to add the additional management packs.

  • Copy the OpsMgr Mgmt pack to the folder where InstallOMMPs.exe is extracted (In this example D:\MP)
  • Add a line with the mgmt pack name on the en of the following section of the Powershell script.


Import of the mgmt packs can be verified in the Management pack folder in Administration pane of the SCSM console.

Installation of the OpsMgr CI connector in SCSM

Follow this procedure to create an Operations Manager 2007 CI Connector:

1. In the SCSM console, click Administration.

2. In the Administration pane, expand Administration, and then click Connectors.

3. In the Tasks pane, under Connectors, click Create Connector, and then select Operations Manager CI Connector.


4. On the General page, in the Name box, type a name for the new connector. Make sure that Enabled is selected, and then click Next.


5. On the Server Details page, in the Server name box, type the name of the server that is hosting the Operations Manager root management server.

Under Credentials, either select the Run As account you created for the Alert connector and proceed, or click New and in the User name, Password, and Domain fields, type the credentials for the Run As account, and then click OK.

Test the connection before preceding the wizard.


6. On the MP Selection page, either click Select all or select the management packs which define the configuration items you would like to import, and then click Next.


7. On the Schedule page, adjust the Synchronization schedule as needed and click Next.


8. On the Summary page, review the configuration and then click Create.

9. On the Completion page, click Close.


To validate the creation of an Operations Manager 2007 CI Connector

  • Objects discovered by Operations Manager are listed as Configuration Items in Service Manager.
  • Confirm the status of a connector by viewing the columns in the Connector pane where you will find information such as Start Time, Finish Time, Status, and Percentage.


Create Views for the imported CI’s

Configuring the OpsMgr CI Connector indicates that additional Configuration Items are required in SCSM. SCSM does not have system-defined views or forms for some items, like imported items via the OpsMgr CI Connector. Own created views can make this CI’s visible in the SCSM console.

Follow the procedures below to create a view for imported SQL Server database configuration items.

1. In the Service Manager console, select Configuration Items.

2. In the Configuration Items pane, right click Configuration Items, and then click Create folder. (This is an optional step, you can create own views in existing folders)


3. In the Create folder page, provide a name for the folder and the management pack to store the information. Keep in mind to organize your information in the proper mgmt. packs. In this example we use an own created mgmt. pack for Views.


4. Back in the Configuration Items pane, select on the just created folder. In the Tasks pane, click Create View.

5. In the Create View dialog box, on the General page, in the Name text box, type a name for the new view. For example, type SQL Databases.

In the Description box, enter a description of the view you are creating. Click OK.


6. Drill down to the Criteria section,Search for objects of specific class, click Browse.

7. In the Choose Class dialog box, in the View list select All basic classes.

8. In the Search text field, type SQL, and then click the search button (blue magnifying glass).

9. In the Class list, select SQL database, and then click OK.


10. No further criteria are required for this example and we can remove the existing criteria from the box.


11. Click the Display tab then in the Columns to display list, select Database Name, Database Size (MB) String, and other items that could be interested for as console info. Click OK.


12. Select the new view named SQL Server Databases to see the list of the imported SQL databases.


All done…



Kurt Van Hoecke

This is a second post in the importing data into SCSM series:

Part 1: (Importing data into SCSM (part 1) – the SCSM AD & SCCM connectors)

Part 2: (Importing data into SCSM (part 2) – the SCSM OpsMgr Alert connector)

Digg thisTweet about this on TwitterShare on LinkedInShare on Facebook