User IDs changing to sys ID when users deleted in AD

robertpetrovics
Tera Contributor

Hi Guys! As the title says when users get deleted in AD the user ID in the sys_user table changes to a sys ID. I searched for this sysID but did not managed to find it in Service now and I don't have access to AD to check there. What I'm curious about is the behaviour of changing the User ID into a sysID, is this an OOB thing?

 

Many thanks!

5 REPLIES 5

SN_Learn
Kilo Patron
Kilo Patron

Hi @robertpetrovics ,

 

Please check the history of the user record and verify the changes done on the userID field was done by the same user which is being used for the AD integration setup in ServiceNow.

 

You have to check Business rule defined on the [sys_user] table it may be responsible for updating it.

 

Mark this as Helpful / Accept the Solution if this helps

----------------------------------------------------------------
Mark this as Helpful / Accept the Solution if this helps.

Robbie
Kilo Patron
Kilo Patron

Hi @robertpetrovics,

 

To answer your question directly - when updating or removing the User ID (column name: user_name), it is not OOB behaviour to replace this with the sys_id.

 

However, this is based on a OOB configuration where the User ID field is not mandatory, meaning it can be empty.

I appreciate on the screen shot you've provided, it is also not mandatory, but I would suggest this update is caused either by the AD integration, or plugin, or a Business Rule on the User table (table name: sys_user) which is setting this.

As @SN_Learn has suggested, to find out a little more and help you determine exactly where this maybe happening or what user (system or AD integration user for example), chec the 'history' of the record. This is possible if the user table is audited (Which is not set by default OOB)

 

To view the history, simply open the user record as provided, and in the grey bar at the top of the form, right click and view the history

Also - tip, when sharing images, I would remove any PII (Personal Identifiable Information such as names and email addresses).

 

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.



Thanks, Robbie

 

robertpetrovics
Tera Contributor

Thanks for the tips 😄

No worries @robertpetrovics - happy to help. Can I help any further?

 

Please can I ask - in order to help others and for me to gain recognition of my efforts, please mark this response correct by clicking on Accept as Solution and/Kudos.

 

Thanks, Robbie