How to find how many groups are there with empty group members in Servicenow?

Pandu8
Kilo Contributor

How to find how many groups are there with empty users in Service now?

1 ACCEPTED SOLUTION

felladin
Tera Guru

Hello,

If you don't need it in a report, this can be run as a normal Background Script for immediate respons.

var total = 0;
var group = new GlideRecord('sys_user_group');
group.addActiveQuery();
group.query();
while(group.next()){
var member = new GlideRecord('sys_user_grmember');
member.addQuery('group',group.sys_id);
member.query();
if(member.next()){
}
else {
total += 1;
}
}
gs.print(total);

View solution in original post

5 REPLIES 5

Pandu8
Kilo Contributor

Thanks a lot for your helpful Information.