Report on Assignment Groups, Users, and Roles

[Community Alums]

I need to create a report that shows Users, their assignment groups, and only the roles assigned by the groups. It does not need to show the contain roles. Just the roles granted by the groups. What is the best way to do this. I have tried to run a report of roles users have but it only gives the contained roles.

[AndersBGS]

Hi @Community Alums 

Do you mean their assigned groups or the assignment groups that the single user belongs to?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Community Alums]

The assigned group the users belong to and the roles the group grants.

[SAI VENKATESH]

Hi @Community Alums 

For your Following Requirement You can take a look on this:

database view called, "matching_user_group_skills".

All the data you need should be in there.

It joins:

sys_user

sys_user_grmember

sys_user_has_skill

user_task_stats

sys_user_has_role

By using the table called "matching_user_group_skills" you can create a report as per your needs.

Thanks and Regards

Sai Venkatesh

[Amit Verma]

Hi @Community Alums 

If I understood your requirement correctly, you want to find out the roles provided by a group to it's group members. If yes, you can query "sys_group_has_role" table to find the roles being offered by a group. Refer below screenshot :

Thanks and Regards

Amit Verma