in microsoft SCCM integration I am not getting data in most frequent logged in user field

[vijayaram]

in microsoft sccm integration in servicenow I am not getting data in most frequent logged in user field in cmdb_ci _computer table

[Viraj Hudlikar · Accepted solution]

Hello @vijayaram 

Did you check using IntegrationHub ETL for "SG-SCCM Computer Identity" data source is there mapping done for this field, as per my knowledge there is not OOTB mapping for this field. If it is not is present you will need it to get mapped.

Below are some screenshot for your reference:

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.

[Brian Dolinar]

Additionally, go to the "Transform Data" tab on the ETL screen. Once there, use the 3-line context menu (aka hamburger menu) to the LEFT of the field in question.  In this case, the "assigned_to" field.  Click on that an then "View Transform" to see the script logic being used to query the sys_user table.