How To Export Associated Groups & Roles

[MrDevanWright]

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? 

[KB18]

Dear @MrDevanWright 

Please use this table to get group and all roles associated with it.

https://dev×××××.service-now.com/sys_group_has_role_list.do

[MrDevanWright]

sys_group_has_role.list is great! That gets me the closest to what I am looking for. Can you think of any way to show any potential child groups and their assigned roles?

[sakeleo213]

As you want excel spread sheet for the group and their associated roles. 

Please create a database view on the basis of Group [ sys_user_group], Group Member [sys_user_grmember_list] and Roles [sys_group_has_role]  table and once database view is created, right click on the any column in the list and export it.

GTA 5 Apk OBB