Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Inheritance Map for all roles

muhammed
Kilo Contributor

Hello,

is it possible to create an inheritance map which shows the relations/connections of all roles.

Thanks in advance.

Muhammed

1 REPLY 1

mike_bush
Kilo Guru

Muhammed,



You've spotted that roles can contain other roles - a very powerful facility (one could say "vital facility")



The linkage is maintained via an "mtm" type table called sys_user_role_contains



Out-of-box the ROLE view has ONE Related List called "Contains Roles" which points "down" the hierarchy.



I find it VERY useful to add the "reverse" related list - "Contained By" since that allows me to look "up" the hierarchy.



This may well give you all the answer you need, if not try writing a report around the mtm table.



Mike