Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

String
Kilo Sage
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!
0 REPLIES 0