Service Graph Connector for Microsoft SCCM
Summarize
Summary of Service Graph Connector for Microsoft SCCM
The Service Graph Connector for Microsoft SCCM enables ServiceNow customers to import data from Microsoft System Center Configuration Manager (SCCM) or Microsoft Endpoint Configuration Manager (MECM) into their ServiceNow Configuration Management Database (CMDB). This integration supports detailed hardware and software inventory tracking by pulling information about computers, processors, operating systems, disks, networks, and software. It is a read-only integration that does not write back to the SCCM database.
Show less
Key Features
- Data Import and Mapping: SCCM data is mapped and transformed into CMDB configuration item (CI) classes using the Robust Transform Engine (RTE) and inserted using the Identification and Reconciliation Engine (IRE).
- Supported Data Sources: Includes multiple SCCM data sources such as computers, disks, networks, operating systems, processors, removed software, and software usage, with specific handling if Asset Intelligence is enabled in SCCM.
- Integration Management: Connector configuration and lifecycle management are handled through the SGC Central view in the Service Graph or CMDB Workspace, supporting discovery, installation, monitoring, and debugging of connections.
- CMDB Integrations Dashboard: Provides centralized monitoring of all integration runs, showing status, results, and errors with filtering options.
- Use Case Integration: Supports key ServiceNow applications including IT Operations Management (ITOM) Visibility for infrastructure visibility and incremental imports, IT Service Management (ITSM) for incident and change management on discovered CIs, and Software/IT Asset Management (SAM/ITAM) for software tracking, usage monitoring, and license reclamation.
Important Configuration and Operational Notes
- After upgrading, remove the
lastrundatetimevalue from the Data Source table for SCCM sources to avoid import issues. - To include network adapters missing IP or MAC addresses, the default SQL filter must be removed from the
SG-SCCM Networkdata source. - Software Asset Management integration varies depending on whether Asset Intelligence is enabled in SCCM; different data sources must be run accordingly.
- The connector imports data into specific CMDB tables such as Computer, Disk, IP Address, Network Adapter, Serial Number, Software Installation, and Software Usage for effective asset and configuration management.
- Use the IntegrationHub ETL app to view and manage data maps for the integration.
Supported Versions
- Microsoft SCCM/MECM versions: 2503 and 2409
- ServiceNow platform versions: Xanadu, Yokohama, and Zurich
Next Steps for Customers
- Configure the connector using the SGC Central view within the Service Graph or CMDB Workspace for guided lifecycle management.
- Use the CMDB Integrations Dashboard for ongoing monitoring of integration health and data processing.
- Follow upgrade instructions carefully, especially related to clearing
lastrundatetimevalues to ensure smooth imports. - Adjust data source queries as needed to capture all relevant network adapter data.
- Leverage the integration to enhance ITOM visibility, ITSM workflows, and SAM/ITAM processes for more accurate and efficient asset and configuration management.
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:
- 2503
- 2409
- Supported ServiceNow versions:
- Xanadu
- Yokohama
- Zurich
Use cases
- 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 ServiceNow AI 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
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).
- SG-SCCM Computer IdentityYou 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 .
- 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
- 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 for more information.
Resolving the missing IP address or MAC address issue
- Navigate to .
- Select SG-SCCM Network.
- Remove the where clause from the SQL statement field.
Additional resources
- How do I configure the SG-SCCM Service Graph Connector? article on the ServiceNow Community site
- Service Graph Connector for Microsoft SCCM - FAQ and Troubleshooting blog post on the ServiceNow Community site
- Service Graph Connector for Microsoft SCCM 3.0 Setup Guidelines [KB1001248] article in the Now Support Knowledge Base
- Support for Removed Software functionality in Service Graph Connector for SCCM integration blog post on the ServiceNow Community site