Service Graph for SCCM - Change assigned to mapping

Justin Clarke · ‎12-13-2021

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 · ‎12-13-2021

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:

View solution in original post

Dallas Fanchier · ‎12-14-2022

I created the user table lookup like you recommended but am not returning results. I was told that the domain\ shouldn't be a problem. What am I doing wrong?