Investigating Unrelated Serial Numbers in CMDB Related List from Microsoft Intune SGC Integration

[hvrgrp]

I am a seasoned ServiceNow developer with over 1 years of experience, and I'm seeking insights into an issue we're encountering with data mapping from Microsoft Intune to our CMDB via the Service Graph Connector (SGC) for Microsoft Intune.

Setup Overview

• We are using the Service Graph Connector for Microsoft Intune to import device data into ServiceNow.
• Data is pulled from Microsoft Intune (via Microsoft Graph API) and loaded into a staging table (e.g., an import set table extending from imp-import-set-row, such as sg-intune-device or similar). This staging table contains fields like device name, serial number, category, IP address, and others.
• The staging table serves as the source, and the data is transformed and inserted/updated into destination CMDB tables, such as cmdbcicomputer.
• In the cmdb-ci-computer records, there is a related list displaying columns that include serial numbers associated with the CI. For example, serial numbers like D80HL04 and J90HL84 appear correctly related to the CI, but other serial numbers show up that are not related to this CI and are not present in the staging table.

Issue Description

The unrelated serial numbers in the related list do not originate from the current Intune import (they are absent from the staging table), and we need to determine:

• How the overall mapping and transformation process works between the Intune staging table and CMDB tables (e.g., cmdb-ci-computer), particularly for fields like serial number and any relationships or related lists.
• What mechanisms (e.g., Identification and Reconciliation Engine (IRE) rules, transform maps, robustness rules, or other integrations) could cause these unrelated serial numbers to appear in the related list.
• Potential causes for such discrepancies, and how to troubleshoot them.

I have conducted deep research across various resources but have not found a definitive explanation for this specific behavior.

If anyone has encountered similar mapping or related list issues with the Intune SGC, or can provide details on the exact data flow (e.g., specific transform maps, IRE payloads, or relationship definitions for serial numbers), your expertise would be greatly appreciated. Please share any relevant configurations, scripts, or troubleshooting steps.

Thank you in advance for your assistance!

I have attached images for your reference.