Audit Changes to User Record

[jrusso]

I am looking for a way to track changes to a user's User ID.  I can't seem to find the right log to report on this.

We have a process whereby contractors who are converting to an employee, have user ID changes and subsequently an employee number change in Workday.  The Workday integration changes the user ID in SNow, but does not change the employee number.  I would like to get a daily audit (or view a log) of all User IDs that were changed the previous day, so i can update the employee number.

Any suggestions?

[Jaspal Singh]

You need to sys_history_log table. Better avoid.

Why not create a Business rule that runs on User table when User ID changes & updates the Employee number accordingly.

[jrusso]

Thanks.  I did see that table, but it did not seem to be listing all of the changes.

I may try the business rule.  Thanks for the suggestion.

[jrusso]

If I don't want to update the Employee Number, but want to review the changes first, could I create a report or notification instead?

[Susan Britt]

Baseline functionality, the User table is not audited to track changes due to the number of entries it'd make tracking logins, etc.  You can enable auditing on sys_user, if desired.  https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/security/task/t_Ena...

I'm not sure if there is a business reason for it, but the Workday integration can update the employee number if desired so you don't have the manual intervention on this step.