To Get the Report of Users and Sys ID

[sanithakavungal]

Hi All,

Is it Possible to Get Report with User Name and Sys ID.

Please help..

User Name	Sys ID

Regards,

Sanitha

[vinothkumar · Accepted solution]

Hi Sanitha,

Please check the below link it would be helpful

Need to be sys_id in export files

[Chuck Tomasi]

Hi Sanitha,

This comes up from time to time and while there is a way, it's not the simplest thing to do. I'm curious what the use case is? Can you help me understand why would someone want a report with a sys_id on it?

[sanithakavungal]

Hi Tomasi,

The sys ID was used for another application linked to Service Now where we distinguish VIP users with sys ID.

Below url will generate all fields of user table in CSV format   including sys_id as well.

https://myinstance.service-now.com/sys_user.do?CSV&sysparm_default_export_fields=all

Regards,

Sanitha

[Kalaiarasan Pus]

Using Sys_id would not be a sensible solution as the sys ID's might be different in different instances.

Have you thought about using the 'VIP' field on the user profile? Add the field to the form layout if it isn't already available.