Service Graph for SCCM - Change assigned to mapping

[Justin Clarke]

I am looking to change from the old SCCM Connector to the Service Graph connector for SCCM.

One issue i have is the assigned to on computer objects comes through as domain\username format
but our servicenow users come from Azure AD and no nothing about domain\username format.
I am able to adjust the sql script from SCCM to pull in the users email address as an additional field.

How do i adjust the robust transform to map this email address field to the computer assigned to field during import?

[ram_mandadapu · Accepted solution]

You can use 'User Lookup' RTE operation to get user reference. Update the 'Assigned to' field mapping on Computer CI to new output field. 

Use 'IntegrationHub ETL' to make this change. 

Video on how to use ETL: https://youtu.be/YvsCY0M7JLw

REF:

 

[Paul Ciarfella]

How do you implement this recommendation in the SCCM service graph connector, where the robust transform is making the assignment?  How Robust Transform Maps work is a mystery to me.  Its the most convoluted ETL process that I've ever seen.

So I had a similar requirement.  My solution was to add a new Robust transform engine entity operation that mapped my user field to the temp_computer_record.assigned_to field.

In this case,  

- Source field would be the imported user's email

- Target field is temp_computer_record.assigned_to

and the script would do the user lookup.

[Mike Marson]

@Paul Ciarfella,

From your attached screenshot, it looks like you are directly manipulating the low level RTE metadata tables e.g. sys_rte_eb_script_operation.   This is not recommended, as the structure of these tables is not oriented towards direct user interaction (as you also observed).   

As previously noted, it is strongly recommended to use the IntegrationHub ETL app instead, which is freely downloadable from the ServiceNow store.  This gives a nice interface for implementing custom transform operations, and being able to see the results in real time with real data.  IH-ETL will handle all the resulting changes in sys_rte_eb* tables.

Simple video on how to use IH-ETL: https://youtu.be/YvsCY0M7JLw

There is also a recommended training course on SG-SCCM that covers many aspects including customization, available through NowLearning.  This is a great way to gain understanding of Service Graph Connectors and how they work.  

Regards,

Mike

[Paul Ciarfella]

Thanks for the guidance Mike.

I'll review the training course to learn the correct way to modify the SCCM import.