How to build a report to find which groups have members with the role B (knowing the group has role A and not all members of the group have role B, that was givent to them individually)

[Bernard12]

Hi Everybody,

Context: no Performance Analytics, no admin rights (just report admin), no coding.

I already know:

• [sys_group_has_role] 
• [sys_user_has_role]
• [sys_user_grmember]

I'd like to make a report to find which groups have members with the role B (knowing the group has role A and not all members of the group have role B, that was givent to them individually).

Many thanks for any idea.

Kind regards.

Bernard

[andersbogsjo]

Hi Bernhard!

You can use Related List Condition on the Report.

report on table sys_user

See my example.

This will Create a report on users in sys_user table that have the role itil. (just change what role you want for your purpose.

Regards

Anders

[Bernard12]

Hi Anders,

Many thanks for this first answer, but where are the different groups to which the user belong ? Knowing almost all users belong to many groups (in addition to the default group that is the only one that you can pick in the [sys_user] table), I'd like to have all the groups, where there are users that have individual role B.

Kind regards.

Bernard

[andersbogsjo]

Hi Bernhard!

I don't quite follow you. Do you want which grups that have role B?

Regards

Anders

[Bernard12]

I'd like to build a report that finds all groups, where there are users with role B (this role B has been given to the user, user by user, not by inheritance of a group).

Example: We have, let's say,300 groups. Each group has several roles such as ITIL, SLA reader, report manager, etc...

Some of the users were given individually a role Change_Approver, not by inheritance. 

So, I'd like to build a report to find all groups that include at least one user that has the role Change_Approver, knowing the role Change_Approver was not given to the groups (except one). Detail: the result must be a list of groups with the name of the group.

Is that clearer now ? Sorry if it was confusing.

Thanks again.

Kind regards.

Bernard