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

[Srikanth_9]

Hi @AshokY,

Yes, you can fetch the common assignment group that contains maximum number of users from the provided list.

1. Filtering the Users list with Assignment Groups.

2. Exporting the data into Excel/CSV and adding a pivot.

3. Creating the Reports.

If the provided solution is useful/working, please Accept as Solution and hit the Helpful. 

Thanks & Regards,

Srikanth Akula.

[Ankur Bawiskar]

@AshokY 

this is an easy requirement within ServiceNow

You can also export data from sys_user_grmember as Excel and do this in Microsoft Excel as well

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Shashank_Jain]

Hello @AshokY ,

If you are looking for : Among all assignment groups, which group has the highest number of users from my given list of 3000 users?

You can simply Navigate to sys_user_grmember.list and group by the field Group.

It will show you number of users in each group.