How to find a Group whose group member is zero

[Community Alums]

Need script for finding a group whose group member is zero.

Thanks

Utsav

[Harish Bainsla]

var groupGr = new GlideAggregate('sys_user_group');
groupGr.addActiveQuery();
groupGr.addAggregate('COUNT', 'sys_user_grmember', 'group');
groupGr.groupBy('sys_id', 'name');
groupGr.query();
while (groupGr.next()) {
var groupId = groupGr.getValue('sys_id');
var groupName = groupGr.getValue('name');
var memberCount = parseInt(groupGr.getAggregate('COUNT', 'sys_user_grmember', 'group'));

if (memberCount == 0) {
gs.info("Group with zero members: " + groupName);
}
}

if you get answer please mark helpful and accept solution

[Harish Bainsla]

hi please accept solution if you get answer