https://www.servicenow.com/community/community-central-forum/roles-inherited-from-servicenow-express/m-p/3047128#M893 <P>My current employer are using Servicenow Express.</P><P>We are trying to analyse their current&nbsp;sys_user_has_role list.</P><P>My previous employer used a MID server that pulled in users and groups and we have roles setup via groups in Servicenow so when roles were added you can see in the inherited/granted by column to see which group the role came from.<BR /><BR />Current Servicenow Express has DWH user, group push and inherited by, granted by is all empty.</P><P>However the inheritance map shows where the role came from.</P><P>Is there a way I can extract this data in a excel format for analysis? Was thinking database view but which tables does the inheritance map use?</P><P>&nbsp;</P> Tue, 17 Sep 2024 07:21:13 GMT pokai 2024-09-17T07:21:13Z https://www.servicenow.com/community/community-central-forum/roles-inherited-from-servicenow-express/m-p/3047128#M893 <P>My current employer are using Servicenow Express.</P><P>We are trying to analyse their current&nbsp;sys_user_has_role list.</P><P>My previous employer used a MID server that pulled in users and groups and we have roles setup via groups in Servicenow so when roles were added you can see in the inherited/granted by column to see which group the role came from.<BR /><BR />Current Servicenow Express has DWH user, group push and inherited by, granted by is all empty.</P><P>However the inheritance map shows where the role came from.</P><P>Is there a way I can extract this data in a excel format for analysis? Was thinking database view but which tables does the inheritance map use?</P><P>&nbsp;</P> Tue, 17 Sep 2024 07:21:13 GMT https://www.servicenow.com/community/community-central-forum/roles-inherited-from-servicenow-express/m-p/3047128#M893 pokai 2024-09-17T07:21:13Z