How To Export List of Users with Individually Assigned Roles

[MrDevanWright]

I'm looking to find all users that have assigned roles that were not inherited by a group. Is there an easy report or export that can show all these users and the roles they have been individually/uniquely assigned?

[Sumanth16 · Accepted solution]

Hi,

Please refer to the sys_user_has_role table.

Please refer below thread:

https://www.servicenow.com/community/developer-forum/how-to-generate-a-user-role-inherited-from-grou...

Thanks & Regards,

Sumanth Meda

[Community Alums]

Hi @MrDevanWright ,

 You can refer to the article and get kick started :https://www.servicenow.com/community/now-platform-articles/visualize-user-s-role-inheritance-map/ta-...