Service Graph Connector for Microsoft SCCM (3.6.0)

Use the Service Graph Connector for Microsoft SCCM to pull data from Microsoft System Center Configuration Manager (SCCM) into your ServiceNow instance.

The Service Graph Connector for Microsoft SCCM (SG-SCCM) imports SCCM data into the ServiceNow® Configuration Management Database (CMDB) application. The integration does not write to the SCCM database and supports the Microsoft Endpoint Configuration Manager (MECM). The integration pulls data from computers, processors, operating systems, disks, networks, and software.

Request apps on the Store

Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Supported versions

  • Supported Microsoft SCCM/MECM versions:
    • 2403
    • 2309
    • 2303
    • 2211
  • Supported ServiceNow versions:
    • Vancouver
    • Washington DC
    • Xanadu

Use cases

The following ServiceNow applications have features that interact with the Service Graph Connector:
  • IT Operations Management (ITOM) Visibility
    • Ability to get visibility into your infrastructure.
    • Detailed hardware and software inventory tracking. The tracking can be done with or without Software Asset Management (SAM).
    • Ability to detect delta changes for efficient incremental imports from SCCM to the Now Platform.
  • IT Service Management (ITSM)
    • Incidents, problems, and changes on discovered configuration items (CI).
    • Automatic device ownership assignment.
  • Software Asset Management (SAM) and IT Asset Management (ITAM)
    • Tight integration with Software Asset Management Professional and client software distribution workflows.
    • Inventory Software package and installation tracking.
    • Software Usage tracking.
    • License reclamation by detecting removed software.
    • Support for software editions, normalizing publisher information, and normalizing product Information.
    • Support for SCCM Asset Intelligence.

Important information for upgrading Service Graph Connector for Microsoft SCCM

After you've installed the latest version of the Service Graph Connector for Microsoft SCCM, ensure that you have removed the last_run_datetime field value from the Data Source [sys_data_source] table for the SCCM data sources.

Configuring a connection for the connector

You can configure a connection for the connector by using the SGC Central view in the CMDB Workspace. The view enables you to discover and install connectors, and then effectively manage the full life cycle of creating, editing, monitoring, and debugging connections. To configure the connector using SGC Central, see Configure Service Graph Connector for Microsoft SCCM using SGC Central.
Important: Unless there are configuration issues, use the SGC Central view in the CMDB Workspace to configure the connection for the connector, as the guided setup method is being deprecated. Connections configured through guided setup might not appear in the SGC Central view.

CMDB integrations dashboard

The Integration Commons for CMDB store app provides a dashboard with a central view of the status, processing results, and processing errors of all installed integrations. You can see metrics for all integration runs. You can filter the view to a specific CMDB integration, a specific time duration, or a specific integration run. For more details about monitoring Microsoft SCCM integrations in the CMDB Integrations Dashboard, see Using the CMDB Integrations Dashboard.

Data mapping

Data from the SCCM data sources is mapped and transformed into the ServiceNow CMDB Configuration Item (CI) class definitions using the Robust Transform Engine (RTE). Data is inserted into the ServiceNow® CMDB using the Identification and Reconciliation Engine (IRE).

The SCCM data sources include the following:
  • SG-SCCM Computer Identity
    You can see the following data if it is available in SCCM:
    • Asset Tag. If the Asset Tag data is available, the mapping can be optionally enabled via the guided setup.
    • Assigned
    • DNS Domain
  • SG-SCCM Computer OU. This data source imports data about the Organizational Unit (OU) name. The data is stored in the SG-SCCM Computer Related [sn_sccm_integrate_sccm_2019_computer_related] table. To add the view, open the computer record, click the top header, and select View > SG-SCCM Computer Related.
  • SG-SCCM Disk
  • SG-SCCM Last Discovered Update. This data source will run at the end of the import schedules to update the last_discovered date on the Computer CI. The source will conduct a full pull of all the computers and bring in only the ResourceID and the LastHWScan columns to update the CMDB Computer table.
  • SG-SCCM Network
  • SG-SCCM Operating System
  • SG-SCCM Processor
  • SG-SCCM Removed Software. Ensure the Use last run datetime option is cleared for every run.
  • SG-SCCM Removed Software AI. Ensure the Use last run datetime option is cleared for every run.
  • SG-SCCM Software
  • SG-SCCM Software AI
Note: If you have Asset Intelligence on your Microsoft SCCM instance, you have to run SG-SCCM Removed Software AI and SG-SCCM Software AI. If you do not have Asset Intelligence on your instance, you have to run SG-SCCM Removed Software and SG-SCCM Software.
When you complete setting up the connection, you can configure the integration to periodically pull data from SCCM. The data is loaded into staging tables and then inserted into the following target tables:
  • CI Relationship [cmdb_rel_ci]
  • Computer [cmdb_ci_computer] (required)
  • Disk [cmdb_ci_disk]
  • IP address [cmdb_ci_ip_address]
  • Network Adapter [cmdb_ci_network_adapter]
  • Serial Number [cmdb_serial_number]
  • Software Installation [cmdb_sam_sw_install] (If the SAM application is installed.)
  • Software Instance [cmdb_software_instance] (If the SAM application is not installed.)
  • Software [cmdb_ci_spkg] (If the SAM application is not installed.)
  • Software Usage [samp_sw_usage]

For more information on where data is saved when pulling data from a Microsoft SCCM application, see CMDB classes targeted in Service Graph Connector for Microsoft SCCM.

You can use the IntegrationHub ETL app to view the data maps. See IntegrationHub ETL (3.2) for more information.

Resolving the missing IP address or MAC address issue

By default, network adapters that are missing an IP address or MAC address are not imported. To include these network adapters in the import, do the following:
  1. Navigate to Service Graph Connector for Microsoft SCCM > Data Sources.
  2. Select SG-SCCM Network.
  3. Remove the where clause from the SQL statement field.

Additional resources