Microsoft SCCM Integration 2012

The Microsoft System Center Configuration Manager (SCCM) 2012 integration is a one direction import of SCCM data into the ServiceNow Configuration Management Database (CMDB). Scheduled imports bring relevant data from SCCM tables into the CMDB through the SQL database and map them to the ServiceNow instance. Beginning with this version, either a full data import or an incremental import can be performed. The import is achieved using a JDBC connection via the MID Server. This functionality requires the Integration - Microsoft SCCM plugin and a new table in the SQL Server database.

For SCCM 2012, ServiceNow supports the following SCCM versions:
Table 1. Supported Version
SCCM Plugin Supported Microsoft SCCM Versions Additional Information
SCCM integration version 2012 SCCM 2012 R 1
  • The ServiceNow Integration - Microsoft SCCM V2012 plugin supports Microsoft SCCM 2012 release 1.
  • Microsoft SCCM 2012R2 server has not been tested by ServiceNow. However, customers have reported success using it with the Integration - SCCM 2012 plugin

Version 2012 Overview

Version 2012 is designed to work with SCCM 2012 release 1.

It comes with default table views and related column names from SCCM 2012. Version 2012 can work with SCCM 2007, but it will require configurations on the table name and column names for certain data source imports.

A major difference between version 3.0 and SCCM 2012 is that a flat table is no longer needed for the import. Instead, data is imported from the Computer Identity data source table within SCCM. The table can be easily extended and configured to include additional information.

SCCM 2012 also provides three transform maps for a software import. Only one transform map can be enabled at a time.
  1. SCCM 2012 Software - Full Import
  2. Incremental Import
  3. Incremental Import (SAM enabled)

The first transform map performs a full import of the software data. This transform map automatically populates into the cmdb_ci_spkg and cmdb_software_instance tables or the cmdb_sam_sw_install table depending on if the Software Asset Management plugin is enabled. If the plugin is not enabled, the former tables are populated; if the plugin is enabled, the latter table is populated.

The second and third transform maps perform an incremental import and should be enabled or disabled depending on whether the Software Asset Management plugin was enabled. If the plugin is not enabled, use "Incremental import"; otherwise, use "Incremental import (SAM enabled)". By default, the incremental import transform map is enabled.
Note: ServiceNow SCCM Integration version 2012 supports Microsoft SCCM 2012.

Identifiers

The Microsoft SCCM integration uses CI identification to update CIs created from data imported from SCCM with a resource ID. A Discovery Identifier called SCCM ID & Class Name returns the resource ID of a computer from SCCM and stores it in a table called Source [sys_object_source]. When resource IDs are first imported, either from SCCM or Discovery, ServiceNow populates the Source table with IDs for each CI it identifies. In subsequent imports, if an incoming ID matches that of an existing CI, ServiceNow updates the information for that CI in the CMDB. If the incoming resource ID does not match that of an existing CI, ServiceNow creates a new CI and populates it with the resource ID.

Scripts

Data population scripts added with the Integration - Microsoft SCCM plugin populate the related data in the CMDB for each target CI discovered by the SCCM ID & Class Name identifier.

Software

The Microsoft SCCM Integration version 2012 reconciles the software package count in the records for a CI and removes a software instance from the Software Instance [cmdb_software_instance] table if the software package is uninstalled from the CI.
Note: The table data imported from SCCM in MicrosoftSCCM Integration version 2012 must contain complete data for the CI. ServiceNow assumes that the import represents all relationships that exist and adjusts the CMDB accordingly. Partial data received from SCCM tables can cause the deletion of active relationships.
For a full import, the resulting relationship looks like this:
Figure 1. SCCM 2012 Full Diagram
For an incremental import, the resulting relationship looks like this:
Figure 2. SCCM 2012 Incremental Diagram

Perform Full Import for SCCM 2007 or SCCM 2012

You must re-import all the software records when switching to the SCCM 2007 or SCCM 2012v2 plugin. Only a full import from Microsoft SCCM will allow correct data reconciliation.

About this task

Both plugins track the incremental import of information about software that was uninstalled from CIs. To support this feature, the following fields where added to the tables cmdb_software_instance and cmdb_sam_sw_install (when Software Asset Management plugin is enabled):
  • The SCCM timestamp [sccm_timestamp] field.
  • The SCCM group ID [sccm_group_id] field.
Note: Unlike previous SCCM integration plugins, the same transform map is used for full imports and incremental imports in SCCM 2007 and SCCM 2012v2.
To perform a full data import:

Procedure

  1. Navigate to Integration - Microsoft SCCM 20xx > Data Sources.
  2. Click SCCM 20xx Software.
  3. Clear the Use last run date time box.
  4. Click Update.
  5. Navigate to Integration - Microsoft SCCM 20xx > Scheduled Import.
  6. Click Execute Now.