ServiceNOW Report - Roles Assigned To Group

[t0ny84]

Hi,

Firstly apologies if this is in the wrong location, please move to the correct location if possible.

Does anyone know if it is possible (and how) to create a report that will list out the Group and Roles assigned to it?

I have looked at tables - sys_user_grmember and sys_user_has_role but neither seems to have the data I need.

Thanks in advance,

t0ny84

[Kieran Anson · Accepted solution]

Hello Tony,

The table you're wanting is sys_group_has_role. If you don't see this table within Report Builder, you'll need to amend the system property 'glide.ui.permitted_tables' and add the above table name to allow reporting on it

[t0ny84]

@Kieran Anson 

Thanks so much, will have a play with this table and hopefully get all the information I need.

t0ny84