How can check why SG Intune does not transform UPN to CMDB's assigned to field.

[anhpt]

Hi everyong,

My first question is when using SG Intune to transform device data from MS Intune (using the default feature, not customize anything, except editing the connection), will the UPN data be transformed to CMDB's assigned_to field?(there is a script to do the lookup as I know - CmdbIntegrationUserLookup). If it is, so my second question is How can we know which transform script handle the mapping? my issue currently is when loading the device data from MS intune into staging tables, I checked the stagging table and see the UPN value existed, but when the transformation was completed, I didn't see any UPN mapped to CMDB.

I found the lookup script above, it query the data and field to one of staging table's field called - assigned_to_user. So how i check how assigned_to_user map data to CMDB's assigned_to field?

[Dr Atul G- LNG]

Hi @AJ-TechTrek any thoughts here.

[AJ-TechTrek]

Hi @anhpt 

Request you to please use the ETL Hub (Available on Servicenow Store) for better understanding and visibility of mapping of Attribute , Also you can check the assigned to field mapping then as per your requirement you can use the script to map the field.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

[anhpt]

Hi @AJ-TechTrek ,

Thanks for your response, I already found the solution to resolve my questions. I used both tools IntegrationHub ETL and Service Graph Connector Visualizer (very helpful tools to see how the field map and which operations work on). IntegrationHub ETL also help us if you want to build additional rules during the transform, like lookup rules etc..