We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

is it possible to get report shows users and which roles they have assigned

Leenashah
Kilo Contributor

Hi,

Possible I can run a report where i can see user with their assigned roles in ServiceNow. This is critical. Any help will appreciate. 

Thank you,

12 REPLIES 12

Prasad Pagar
Mega Sage

Hi,

As a admin, You can run report on sys_user_has_role table to get User- Role relationship.

find_real_file.png

Please mark my answer correct/helpful if applicable.

Thank you
Prasad

Hi,

Please refer to this for more info, hope this will help you- 

https://community.servicenow.com/community?id=community_question&sys_id=b772388ddbea9f0023f4a345ca96...

Thanks,

Thank you prasad, 

I just asked ankur same question - 

Thank you but I just export in excel, it was little easy, it possible we can only run a report by specific module, example we have vendor/contract management.  Do you think i can separate, based on Module 🙂 sorry adding additional request

 

thank you,

Hi Leena,

As Ankur said there is no direct way but you can still do one thing

Not a ideal way but it will give you separate report if needed. There is chance of missing any role but you will get 90% of results. see the name of role it will always have module or application in it. For e.g Knowledge, problem, Incident, Change. See if you can utilize it somehow.

find_real_file.png

Please mark my answer correct/helpful if applicable.

Thank you
Prasad