Identify the groups with just one member

LK11
Mega Expert

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

1 ACCEPTED SOLUTION

Patrick Schult2
Giga Guru

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.


Groups with 1 member.png


List v3 groups.png


View solution in original post

9 REPLIES 9

Prateek kumar
Mega Sage

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

kamalsoni
Tera Expert

Hi ,



You can create report as shown in below screenshot.



find_real_file.png


find_real_file.png


The above output you can get and identify group member count.


LK11
Mega Expert

Thank you very much Bradley and Prateek.  


LK11
Mega Expert

Thank you Kamal.   This is another way of doing, nice.


Riya17
Giga Contributor

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?