Service Graph Connector for Intune: How to map IMEI to CI Name field via ETL or BR

[String]

Hello ,

We are using the out-of-the-box Service Graph Connector for Microsoft Intune to ingest data into the CMDB, specifically mapping to the Handheld Computing [cmdb_ci_handheld] table.

We have a requirement to set the primary Name attribute of the CI record to the IMEI value coming from the source data.

What we have tried:

1. "Before" Business Rule on the Target Table: I wrote a simple "before" BR on the cmdb_ci_handheld table:
   javascript

   if (current.imei) {
       current.name = current.imei;
   }

   This approach is not working. The name field remains null or takes the default value defined by the connector's existing logic, likely due to the Identification and Reconciliation Engine (IRE) processing the data payload.
2. ETL Mapping Issue: I understand that modifications should be done within the IntegrationHub ETL definitions. My colleague tried mapping the source IMEI field directly to the target Name field in the ETL mapper, but this caused insertion errors because the source IMEI is an optional field in Intune, while the Name field is mandatory in the CMDB.

The Problem:

I attempted to use a Script Operation in the Prepare Source Data for Mapping step to conditionally set the value (providing a fallback name if IMEI is missing), but the "New Transform" button is greyed out.

My Questions:

1. Why is the "New Transform" button greyed out in the IH ETL Step 2, even when a valid import set is selected in Step 1? (I am in the correct application scope).
2. Is there any reliable method (using a Business Rule, After BR, or specific ETL configuration trick) to set the Name to the IMEI value via the Service Graph Connector framework, ensuring records with missing IMEIs still successfully insert?

We need a robust solution that works within the constraints of the SGC/IRE architecture.

Thank you in advance for your help!

[Matthew_13 · Accepted solution]

@String - 

This is from what I have seen a expected thing with Service Graph and IRE.

Your before BR doesn’t work because IRE sets the Name during reconciliation, and ETL mappings can’t rely on IMEI since it’s optional. The New Transform button is greyed out because most SGC ETLs are OOB-locked.

The clean solution is to leave the connector alone, let the CI insert normally, and use an after business rule or fix script to set name = imei only when IMEI exists. That avoids insert failures and works with IRE instead of against it.  Thumbs up if this helps you, Thanks my friend!