Find duplicate users in two groups

Thomas G · ‎11-17-2022

Hi,

It may sound simple but I can't wrap my head around this one at the moment.

I have two groups and need to find users that are members of both. How can I show those in a report? I guess I should look at sys_user_gr_member table. It is easy to find all users from both groups but how can I find only those that are members of both?

Best regards

Thomas

vikrantsharma · ‎11-17-2022

Hi Thomas,

Can you try Multi-level pivot table.

It gives me a an overview of which user is in which group. Like I have filtered on 3 groups with the below config, it gives me the below result, see if this helps?

Sorry, I have scribbled over user and Group names.

Please make it correct or helpful if this solves or help you with your issue for other to make use it.

Thanks & Regards,
Vikrant Sharma

View solution in original post

Thomas G · ‎11-18-2022

Hi vikrantsharma,

Thanks for trying and I can live without it 🙂

Best regards
Thomas