During a recent client engagement, there was a request to add databases to Service Manager as CI’s. This was in addition to previous requests to add both network devices and VMware servers from OpsMgr into Service Manager. As background the following two articles documented the first attempts I made at synchronizing information from OpsMgr 2012 into Service Manager 2012:

What I’ve found is that the process is actually simpler than what I used historically. The actual required steps are only the following:

 

1) Import management pack (or packs) to Service Manager 2012

2) Change the connector to synchronize the new objects

3) Build a folder and view for the new CI’s

 

Import management pack (or packs) to Service Manager 2012

Since these were SQL 2008 databases, I started from choosing the SQL Server 2008 (Discovery) management pack. It was dependent upon the SQL Server Core Library so that needed to be added and then the SQL Server 2008 (Discovery) management pack could be added. Management packs added into Service Manager 2012:

  • “SQL Server Core Library”
  • “SQL Server 2008 (Discovery)”

clip_image001

clip_image002

Change the connector to synchronize the new objects

Next change the Operations Manager CI connector to synchronize SQL objects by checking the additional management pack shown below.

image

Synchronize the connector and validate successful synchronization.

Build a folder and view for the new CI’s

Built out a folder for SQL and a view for the SQL databases shown below for the SQL Databases.

clip_image004

CI’s now include the SQL Database type which can be added into incidents and such as shown below.

clip_image005

This looks like territory that has been covered before on the following two blog links, but my google (er.. bing?) skills appear to have been lacking when I was originally looking for how this works:

 

Good additional reading on this topic is available at:

http://blog.scsmfaq.ch/2011/02/10/bringing-discovered-scom-objects-to-service-manager-part-12/

http://social.technet.microsoft.com/Forums/en-US/systemcenterservicemanager/thread/626a3b89-cfcd-42f3-b13f-f074b44dbbcf/