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.

Guided setup The guided setup for the Service Graph Connector for Microsoft SCCM provides an organized sequence of tasks to configure the integration on your instance. To access the guided setup, see Configure Service Graph Connector for Microsoft SCCM . Note: When you install and configure the Service Graph Connector for Microsoft SCCM , only active SG-SCCM data sources will be configured with credentials or MID configuration during the guided setup. If a Software Asset Management plugin is enabled after the connector has been installed, any additional SAM-related data sources will not be configured with credentials and will not function correctly. In this scenario, in order for these new SAM-related data sources to function correctly, you must go back into the guided setup for SG-SCCM and re-enter the credentials and MID configuration.

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 the guided setup, 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 <a class="xref" href="integrationhub-etl.html" title="Use the IntegrationHub ETL store app to create and manage ETL transform maps, which integrate third-party data into the CMDB or into non-CMDB tables without compromising the integrity of data. IntegrationHub ETL provides a simplified user interface that guides you through the integration process end-to-end, including a test integration run of sample data.">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: Navigate to Service Graph Connector for Microsoft SCCM > Data Sources . Select SG-SCCM Network . Remove the where clause from the SQL statement field.

Additional resources Service Graph Connector for Microsoft SCCM - FAQ and Troubleshooting blog post on the ServiceNow Community site Support for Removed Software functionality in Service Graph Connector for SCCM integration blog post on the ServiceNow Community site

Related concepts Service Graph Connectors