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:
- How do I integrate Operations Manager 2012 Network Devices into Service Manager 2012 as Configuration Items? https://www.catapultsystems.com/cfuller/archive/2012/07/13/how-do-i-integrate-operations-manager-2012-network-devices-into-service-manager-2012-as-configuration-items-[scsm-scom-sysctr].aspx
- How do I integrate VMware Servers into Service Manager 2012 as Configuration Items? http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/94764/Default.aspx
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)”
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.
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.
CI’s now include the SQL Database type which can be added into incidents and such as shown below.
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: