var gr2 = new GlideRecord('sys_user_role');
gr2.addQuery('name','itil');
gr2.query();
if (gr2.next() ) {
  gs.print('itil group sysid is: ' + gr2.sys_id);
}
 
//var gr = new GlideAggregate('sys_user'); //GlideAggregate query
var gr = new GlideRecord('sys_user');
gr.addQuery('roles','CONTAINS',gr2.sys_id);
//gr.orderByAggregatequery('count'); //Count aggregate ordering
//gr.groupBy('email'); //Group aggregate by the 'os' field
gr
 
 
var gr4 = new GlideAggregate('sys_user_has_role');
gr4.addQuery('role',gr2.sys_id);
gr4.groupBy('user');
gr4.query();

var count count3= 0;
 
while (grgr4.next()) {
  //Print the OS name and count of items with that OS
 //if (gr4.user.active!=false && gr4.user.email != '') {
      gs.print('Distinctone user operatingrecord systemis: ' + gr.os + ': ' + osCount);
 count++;
}gr4.user.email);
      count3++;
  }
}
 
gs.print('count is4p,p,.puixx.eu count: ' + count);count3);

'COUNT');
         if (groups == 1) {
            user_array.push(user_in_group.user.user_name);
         }
      }
   }
   return user_array;
}

function findItil() {
   var user_array = [];
  var role_id = []
  var user_has_role = new GlideAggregate('sys_user_has_role');
  user_has_role.addEncodedQuery('role=b4c1f5331011100094adb14c071ff154^user.active!=false^user.emailISNOTEMPTY^user.user_nameISNOTEMPTY');
  user_has_role.addAggregate('COUNT', 'user');
  user_has_role.query();
  while (user_has_role.next()) {
    user_array.push(user_has_role.user.user_name);
  }
  return user_array;
}

function findFinancialMembersWithNoOtherRole() {
   var user_array = [];
   var user_in_group = new GlideRecord('sys_user_grmember');
   user_in_group.addQuery('group', '4da8813ea1a8990494ad46651315d87d'); //Financial Approvers group
   user_in_group.query();
   while (user_in_group.next()) {
      var group_count = new GlideAggregate('sys_user_grmember');
      group_count.addQuery('user', user_in_group.user.sys_id);
      group_count.addAggregate('COUNT');
      group_count.query();
      var groups = 0;
      if (group_count.next()) {
         groups = group_count.getAggregate('COUNT');
         if (groups == 1) {
            user_array.push(user_in_group.user.user_name);
         }
      }
   }
   return user_array;
}
function arr_diff(a1, a2)
{
  var a=[], diff=[];
  for(var i=0;i<a1.length;i++)
    a[a1[i]]=true;
  for(var i=0;i<a2.length;i++)
    if(a[a2[i]]) delete a[a2[i]];
    else a[a2[i]]=true;
  for(var k in a)
    diff.push(k);
  return diff;
}
function findItilMinusFinancialMembersWithNoOtherRole () {
  var itil_users = findItil();
  var finance_no_role_users = findFinancialMembersWithNoOtherRole();
  gs.print("The length of itil users is: " + itil_users.length);
  gs.print("The length of finance approvers with no other role is: " + finance_no_role_users.length);
  var result = arr_diff(itil_users,finance_no_role_users);
  gs.print("The subtracted set of elements is: " + result.length);
}
findItilMinusFinancialMembersWithNoOtherRole();