I have found a way to be able to sort out list based on number of members is by creating a new field for total number of members.
First, I create a 2 new columns in sys_user_group like Total of Group Member and Total of Active Group Member.
Second, I create a script in Scheduled Job to run and populate data in 2 new columns to show results number of members. Screenshot show below
Third, I create a report based on group and show list of group name, total of group members, and total of active group members. Now I can sort out the numbers. Here screenshot example,
Hi Bradley,
You can sort of do this using a pre-built join, the Groupmember [sys_user_grmember] table.
The UI of ServiceNow reporting is a little constrained, but here's an example as a pivot:
Or as a grouped list:
In both cases, you can't really sort based on the number of group members, or group them by number of members. You can do that with Explore Analytics.
Here's an Explore pivot grouped from largest to smallest groups:
And here's the # of groups grouped by how many members the groups have (there are 4 groups with 8+ members, for example):
Explore Analytics can also do on-the-fly joining without requiring SQL, although I don't think you'd need it here.
