How can I find out which groups contain a role?

chrismarriott · ‎06-05-2017

I'm probably missing something obvious here, but how can I find out which groups contain a particular role in Helsinki? When I look at the details of a role, the "related records" tabs show me which users have that role, but not which groups contain the role. Is there a way I can find out which groups a role has been assigned to?

Thanks,

Chris

amlanpal · ‎06-05-2017

Hi Chris,

You need to search in the Group Role ('sys_group_has_role') table to get your answer. You need to type sys_group_has_role.LIST in your application navigation search bar to open the List view of the table. Please find to the below snapshot where I have filtered those groups which has 'itil' role.

I hope this helps. Please mark correct/helpful based on impact

View solution in original post

snehabinani26 · ‎06-05-2017

HI Chris,

Navigate to the Group table. You can find the related list named as role.

Mihir Mohanta · ‎06-05-2017

You can find it by querying "sys_group_has_role" table.

Shishir Srivast · ‎06-05-2017

Please check in sys_group_has_role to find out the roles for the group.

Kalaiarasan Pus · ‎06-05-2017

On the user profile, add roles related list if not already present.

Change the list layout of the related list and add granted by column.