Report On Group Member Count

[smithro]

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.  

[Kushal09]

This snippet will help you get the number of people in a group of your choice. You can use this in a business rule to update the field of your choice on the form.

var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group.name', '<nameOfGroup>');
gr.query();
var number = gr.getRowCount();

Please mark my answer as helpful/solution if I answered your query
Kushal Bahirwani
Technical Consultant

[Dr Atul G- LNG]

Hi @smithro 

Create report 

Type = Score

No script is required. 

[smithro]

That's not really what i'm looking to do.  I am looking for a way to quickly identify the groups that have zero members.

[Dr Atul G- LNG]

Hi @smithro 

In that case you can go with Pivot table as suggested by @Josh Pirozzi