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