Groups without ITIL users

[afrpereira]

How can I know if there is any groups without ITIL users? 

[Claude DAmico]

I'm not sure about a report. I know that has the ability to do a single related list query on top of the initial query, but we are looking at groups, roles, and users here. I might not know enough to do that. I did put together a little script though.

var arr = [];

var uhr = new GlideRecord('sys_user_has_role');
uhr.addQuery('role', '282bf1fac6112285017366cb5f867469'); //itil role
uhr.addQuery('user.active', true);
uhr.query();

while(uhr.next()){
   arr.push(uhr.sys_id.toString());
}

var grMem = new GlideRecord('sys_user_grmember');
grMem.addQuery('user.sys_id', 'NOT IN', arr.toString());
grMem.query();

var noItilMembers = [];
if(!grMem.hasNext()){
   gs.print("No groups without ITIL users.");
} else {
   while(grMem.next()){
      if(noItilMembers.indexOf(grMem.group.toString()) == -1){
         noItilMembers.push(grMem.group.name.toString());
      }
   }
   gs.print(noItilMembers.toString());
}

[afrpereira · Accepted solution]

I did it! 😁