How to find out which fields in user table are updated?

[saini]

I have asked this question but I think I didnot ask in a right way.

some fields are updated in user table everyday using transform map, how can I find out which fields are updated?

Thanks

[Aoife]

There are a lot of ways, depends on what you are trying to do with this information.

From the UI you can look at the history of the record.

From a business rule script or client script check this page: https://servicenowguru.com/scripting/business-rules-scripting/checking-modified-fields-script/

you can review the staging table that the transform map is reading to see what changes day-over-day.

With a bit more information about what you want to know and how you want to use the information I can give better direction.

Thanks,

Aoife

[asifnoor]

Hello Saini,

You can check the import log and the import sets that is present on the user table and that should give you information on what you are looking for.

[saini]

I need to show the updated fields to the user who cannot access the import set or log, i was wondering if some kind of report or some other way to find the updated field ?

[Mahesh23]

Hi,

Try creating new business rule with below code

var gsr = GlideScriptRecordUtil.get(current);


  gs.addInfoMessage(gsr.getChangedFields());