Find duplicate users in two groups

[Thomas G]

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

[Thomas G]

Thank you, Sebastian!

I guess it would work too, but I go with the multi pivot approach just to simplify things a bit 🙂

Best regards
Thomas

[vikrantsharma · Accepted solution]

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.

[Thomas G]

That is a good solution. Thank you very much!

Best regards
Thomas

[Thomas G]

Hi again 😉

Is it possible to only show those with a count greater than 1, or in other words; those with a count of 2 since those are the only users I wish to show in my report?

Best regards
Thomas

[vikrantsharma]

Hey Thomas,

I tried, but no cigar.

There are some function that we can manipulate, but the count is system generated so it cannot be applied to a filter or in those functions. Only the field on the table could be used in "Configure functional field" or in the filter.