How to find a common assignment group for a given list of users?

[AshokY]

Let's say I have a list of 3000 users with me.

Each user is part of multiple assignment groups.

how to find a common assignment that contains maximum number of users from the given list. 

[Danish Bhairag2]

Hi @AshokY ,

U can open sys_user_grmember table n add all the users from the filter condition like user is one of n paste all the 3000 users.

Post that right click on group column n do a group by groups.

Whichever groups have high count of users will be Ur assignment groups to look into

Thanks,

Danish