How to generate a user, role, inherited from group report

[Rahul165]

I am trying to generate a report from user role table, for all user with their role, inherited count,granted by,included in role columns

The list come with user and htier roles with inherited count

However i cant find how the user inherited this role from which group?

the granted by and included in role columns are blank

[sachin_namjoshi]

you can navigate to sys_user_grmember.LIST  to find out users belong to which group.

Regards,

Sachin

[sachin_namjoshi · Accepted solution]

Also, 

Take a look at the 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

Regards,

Sachin

[Rahul165]

matching_user_group_skills, gave me what I wanted..Perfect. Thanks