Service Graph Connector for Microsoft Intune - add custom field mapping?

Shane J
Tera Guru

‎01-10-2025 08:47 AM

As much as I'd love to drone on about how much 'fun' using IntegrationHub ETL is...


I am trying to populate a field called u_ref_type (Reference type) field from SGC MS Intune for 'Computers'.  I can see the data coming in, and as far as I can tell have the field properly mapped in ETL.  Because the data is coming in as a string, I need to convert that String to a sys_id in order for it to be usable.  

 

I have done this months ago for 'Devices' - HI Support suggested I modify the 'mobiledevices' Data Stream Script parser step to get the value I was looking for.  I figured I could just follow the same steps for 'Computers' (everything else is the same, field names etc) by modifying the 'computers' Data Stream the same way, but in ETL the 'Ref by' just comes across empty.  The portion I updated is shown below (and matches what I did in 'mobiledevices').

 

Note I've done all this work while properly scoped.

 

(function parse(inputs, outputs) {

   var record = JSON.parse(inputs.sourceItem);
    
    outputs.targetObject.id = record.id;
    outputs.targetObject.userId = record.userId;
    outputs.targetObject.deviceName = record.deviceName;
    outputs.targetObject.enrolledDateTime = record.enrolledDateTime;
    outputs.targetObject.operatingSystem = record.operatingSystem;
    outputs.targetObject.complianceState = record.complianceState;
    outputs.targetObject.osVersion = record.osVersion;
    outputs.targetObject.emailAddress = record.emailAddress;
    outputs.targetObject.model=record.model;
    outputs.targetObject.manufacturer=record.manufacturer;
    outputs.targetObject.serialNumber = record.serialNumber;
    outputs.targetObject.wiFiMacAddress = record.wiFiMacAddress;
    outputs.targetObject.managedDeviceOwnerType = record.managedDeviceOwnerType;
    outputs.targetObject.jailBroken = record.jailBroken;
    outputs.targetObject.userDisplayName = record.userDisplayName;
    outputs.targetObject.deviceEnrollmentType = record.deviceEnrollmentType;
    outputs.targetObject.managementAgent = record.managementAgent;
    outputs.targetObject.totalStorageSpaceInBytes = record.totalStorageSpaceInBytes;
    outputs.targetObject.deviceType = record.deviceType;
    outputs.targetObject.freestoragespacebytes = record.freeStorageSpaceInBytes;
    outputs.targetObject.ethernetMacAddress = record.ethernetMacAddress;
    outputs.targetObject.chassisType = record.chassisType;
    outputs.targetObject.userPrincipalName = record.userPrincipalName;
    outputs.targetObject.connectionAliasId = inputs.fd_data.action_inputs.connectionalias.sys_id;
    outputs.targetObject.lastSyncDateTime = record.lastSyncDateTime;
    outputs.targetObject.azureADRegistered = record.azureADRegistered;
    outputs.targetObject.isSupervised = record.isSupervised;
    outputs.targetObject.isEncrypted = record.isEncrypted;

    var ownership = '';
    if (record.managedDeviceOwnerType == 'personal'){
      ownership = '8bf68f231b7142547a8a4111cd4bcb36'; 
    }
    else if (record.managedDeviceOwnerType == 'corporate' || record.managedDeviceOwnerType == 'company'){
        ownership = '47c6cfef1b3142547a8a4111cd4bcbe2';
    }
    else {
        ownership = '201783631b7142547a8a4111cd4bcb04';
    }
   outputs.targetObject.u_ref_type = ownership;

        
})(inputs, outputs)

 

0 Helpfuls
  • 738 Views
1 REPLY 1

Viraj Hudlikar
Tera Sage

‎01-11-2025 02:42 AM

Hello @Shane J 

 

I recommend this article for your concern, if still any concern let me know.
Service Graph Connector for Microsoft Intune - Add... - Page 2 - ServiceNow Community


If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.


Thanks & Regards
Viraj Hudlikar.



0 Helpfuls