Need a report which show all users with their roles assigned in servicenow.

[kumaraj]

Hi , I have 400 SNOW users IDs in excelsheet. Now I need to pull a report to see what are the roles does each user have?  

Exe:

kuma42 - itil, admin, change, incident_user

kuma43 - admin, problem_user, itil 

Please help me to get the report.

Thanks,

[Jaspal Singh · Accepted solution]

Hi Ajeet,

You can try reporting on sys_user_has_role (User Role) table & then you can Group by User.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[kumaraj]

Thank you Jaspal. 

[karma_chamelion]

Hello!,

        Here is a report, where I was looking for users who were "inactive" and still have roles assigned.

This may not be what you are looking for, however I am hoping will give you some ideas.

[Leenashah]

Hi Karna

possible you share more as i am looking for a report where I can see all user with their assigned role? Possible you direct me..

Thank you so much,
leena