Get all users, who are part of the requester's groups

[Harsha Pappala]

Hello guys,

For a catalog request, i want to update all the incidents. Where assigned or caller is a user who is part of requester's group/groups. 

Using below script to get the information. But it is very time taking, as i have to parse multiple incidents.

Could anybody suggest me a better way to do this

var sg = new GlideRecord('sys_user_grmember');
sg.addQuery('user', requester);
sg.query();
var group_list = [];
var num = sg.getRowCount();
while (sg.next()) {
gs.info('groups found' + num);
group_list.push(sg.group);
}

for (var j = 0; j < group_list.length; j++) {

var users = [];
var grp = new GlideRecord('sys_user_grmember');
grp.addQuery('group', group_list[j]);
grp.query();

while (grp.next()) {
users.push(grp.user);
gs.info('user name ' + users[j].getDisplayValue());
}
}

[Willem]

You can try this:

var group_list = gs.getUser().getMyGroups();

for (var j = 0; j < group_list.length; j++) {

    var users = [];
    var grp = new GlideRecord('sys_user_grmember');
    grp.addQuery('group', group_list[j]);
    grp.query();

    while (grp.next()) {
        users.push(grp.user);
        gs.info('user name ' + users[j].getDisplayValue());
    }
}

[Willem]

or even better:

var group_list = gs.getUser().getMyGroups();

var users = [];
var grp = new GlideRecord('sys_user_grmember');
grp.addQuery('group', "IN", group_list);
grp.query();

while (grp.next()) {
    users.push(grp.user);
    gs.info('user name ' + grp.user.getDisplayValue());
}

[Harsha Pappala]

Hi Willem, 

Thanks for the response. But i am trying to execute this on a catalog request. 

There is a requester name field, using whose name i need to gather their groups and users who are part of those groups

current.requester_name.getGroups() ?

I am not sure what to use..

[Willem]

Can you try with:

gs.getUserByID(current.requester_name).getGroups()