Unable to find out which all fields got updated post transform

[SNOW46]

Hello All,

We have a requirement to run a reconciliation report between Oracle and ServiceNow for user records to get updated in SNOW. We usually get an excel sheet that contains all the active users' records information including all the fields.

I have tried loading the data in Import Set and performing the field mapping using Mapping Assist and running the transform on the sys_user table. I can see there are some updates that happened for each and every record with a count of 1. But still I cannot able to figure out as to for which particular field the update has happened for each records.

Can 

Can anyone please help me out on this as this is very urgent for me as I need to showcase a demo on this to our customer on this process?

Thanks

[Anshu_Anand_]

open the records or any one record which got updated/created, right click on the form

and goto history->list

there you can see each fields updated after the transform map run.

Mark answer as correct if its helpful

[Anshu_Anand_]

You have to enable audit for the fields for sys_user table in order to see the history of fields.

Please follow below to turn on audit on sys_user table.

1. Navigate to System Definition --> Dictionary

2.  Open below record for dictionary on your instance.

3.  Click on audit to true for this record and save dictionary record.

After it , run the transform map , or even manually save it 

you can see the history now.

goto sys_user any record

right click on form, goto-history-list

But,

NOTE:-

Auditing the fields that are changed frequently will clog up your history and make it hard to see the important items. It can impact performance and is not recommended .

https://community.servicenow.com/community?id=community_question&sys_id=c57517b5dbc4ebc0b2102926ca96...

Mark answer as correct if it helps

[SNOW46]

Hello Anshu,

Thanks for your information. I have enabled the audit on the sys_user table but how to see all the updates for all the records in one place instead of going to each record and checking the history.

Can you help me to find out the easiest way?

Thanks

[Anshu_Anand_]

You can see on sys_history_line table or check this url

https://<servicenow-name>.service-now.com/sys_history_line_list.do?sysparm_query=set.table%3Dsys_user&sysparm_view=

just group by label

If its helpful, please mark answer as correct