How can I match sys_id to user record?

Sam Taulelei
Kilo Contributor

Hi

 

I have received a compliance list from Service Now for staff with fulfiller roles who are identified by their sys_id.

How can I search/match these sys_ids to user records?

3 REPLIES 3

Harshad Wagh
Tera Guru

if you have a list in excel with sys_id,

Just open "sys_user.LIST" and under filter select "sysid is one of" and paste the list of sys_ids there.

find_real_file.png 

Musab Rasheed
Tera Sage
Tera Sage

Hello,

You can extract user list from sys_user table and make sure you include any method mentioned below to include sys_id while exporting users so after that you can compare easily in excel sheet

https://www.servicenowelite.com/blog/2020/9/29/ten-methods-to-find-sysid

Please hit like and mark my response as correct if that helps

Regards

Please hit like and mark my response as correct if that helps
Regards,
Musab

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you can try what's mentioned by Harshad

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader