How To Export Associated Groups & Roles

MrDevanWright · ‎05-09-2023

I'm trying to obtain an excel spread sheet of all the groups, child groups, and their associated/inherited roles. Is there a way to export some file showing these relationships?

Ratnakar7 · ‎05-09-2023

Hi @MrDevanWright ,

Yes, you can export this information using ServiceNow's reporting functionality. Here are the steps:

Navigate to the "Reports" module in the left-hand navigation menu.
Click on "Create" to create a new report.
Select "Table" as the type of report.
Choose the table "sys_user_group" as the table for the report.
Add the columns "Name", "Parent", and "Roles".
In the "Filters" section, add the filter "Active is true".
Click on "Run" to run the report.
Once the report has run, click on the "Export" button and choose the format you want to export the data to (e.g. Excel).

If my response was helpful in resolving the issue, please consider accepting it as a solution by clicking on the ✅Accept solution button and giving it a thumbs up 👍. This will benefit others who may have a similar question in the future.

Thank you!

Ratnakar

MrDevanWright · ‎05-12-2023

Thank you for the helpful response. However, I am running into a few issues.

First, it appears PDF is the only file type available to download. Do you know how to make other file types such as XLXS or CSV available for download? Secondly, this report isn't showing all the roles associated with the groups, even though I am the admin (also security_admin) for this instance. Please see the attached images for examples of the issues.

Ratnakar7 · ‎05-14-2023

Hi @MrDevanWright ,

You can get XLXS formatted report with schedule feature of report like below:

->>Click on "Schedule" option:

-->> Select Type as "XLXS"

Also, to get report on all the roles associated with particular groups, you can create new report on table "sys_group_has_role", as below:

Thanks,

Ratnakar

MrDevanWright · ‎05-15-2023

This appears to have the same issues. It's not showing ALL the roles assigned to each group. Please see attached screenshots.