question ServiceNOW Report - Roles Assigned To Group in Community Central forum

ServiceNOW Report - Roles Assigned To Group

t0ny84 — Fri, 17 May 2024 07:17:16 GMT

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

Re: ServiceNOW Report - Roles Assigned To Group

Kieran Anson — Fri, 17 May 2024 13:26:19 GMT

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

Re: ServiceNOW Report - Roles Assigned To Group

t0ny84 — Tue, 21 May 2024 05:12:47 GMT

@Kieran Anson

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

t0ny84