- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2017 07:05 AM
At the moment some of the approval groups have just one member in the group. I have to identify those groups so that we can add additional members. How can I find the gorups with just one member?
Thanks
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2017 07:14 AM
You can use a report (or list V3) to query for groups that have exactly 1 group member. See screenshot for an example.
If you don't have list v3 or the Istanbul+ report builder enabled, you will need to write a script. The script would query for all groups, then for each group, get the count of the group members. If the count of the group members is exactly 1, then you would write it to the log or do something else with it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2017 07:26 AM
This thread might help you
How to lists all groups with number of group members?
Please mark my response as correct and helpful if it helped solved your question.
-Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2017 07:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2017 07:50 AM
Thank you very much Bradley and Prateek.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2017 12:07 AM
Thank you Kamal. This is another way of doing, nice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2018 07:58 AM
I have a similar requirement. If the report is on 'Group member' table, the groups returned may not necessarily be approval groups. Is that right?