Report On Group Member Count

Go to solution
smithro
Tera Guru

‎11-30-2023 05:43 AM

What is the easiest way to build a query that tells me how many active members are in a Group?  We have hundreds of groups, so this would be a helpful admin tool.  I think ideally I'd like an integer field on the group table that counts number of active members.  From there I could add the field to the group list view for sorting.  The field would also need to display a zero for those groups with no active members.  

0 Helpfuls
  • 2,283 Views
1 ACCEPTED SOLUTION

Go to solution
Josh Pirozzi
Kilo Sage
In response to smithro

‎11-30-2023 07:23 AM

Hi @smithro , 

Correct. The first response I added will provide Groups that have Zero Group Members associated to them.

Thank you,

Josh Pirozzi

View solution in original post

0 Helpfuls
11 REPLIES 11

Go to solution
smithro
Tera Guru
In response to Josh Pirozzi

‎11-30-2023 07:31 AM

This will work.  Thanks for your assistance.

0 Helpfuls

Go to solution
Dr Atul G- LNG
Tera Patron
Tera Patron
In response to smithro

‎11-30-2023 07:29 AM

No sure about exact requirement, but show the group where NO member, which help you to investigate why this group exits and you can remove / delete the group. 

 

Also add a check, group Active = True

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************