How to add multiple users through script in group table for a custom Multi select field

[Harsha M V]

Hi All,

I am getting users list from ABCDEFGHIJK group(which is a Owners group) and for those users i am adding them to 

u_group_manager field for which all groups they are part of.

While adding, if 2 users are part of same group then its updating the custom field with latest user in the while loop and removing the added user.

I have to add it one by one and should not remove the added ones, something like adding multi users.

This is below script please help

var gr_rec = new GlideRecord('sys_user_grmember');
gr_rec.addQuery('group.name', 'ABCDEFGHIJK');
gr_rec.query();

while(gr_rec.next())
{
var usr_rec= new GlideRecord('sys_user_grmember');
usr_rec.addQuery('user', gr_rec.user);
usr_rec.query();

while(usr_rec.next()){

var gr_grp= new GlideRecord('sys_user_group');
if(gr_grp.get('name', usr_rec.group.name))
gr_grp.u_group_manager = usr_rec.user;

gr_grp.update();

}

}

[Ankur Bawiskar · Accepted solution]

update as this

var gr_rec = new GlideRecord('sys_user_grmember');
gr_rec.addQuery('group.name', 'ABCDEFGHIJK');
gr_rec.query();

while(gr_rec.next())
{
var usr_rec= new GlideRecord('sys_user_grmember');
usr_rec.addQuery('user', gr_rec.user);
usr_rec.query();

while(usr_rec.next()){

var gr_grp= new GlideRecord('sys_user_group');
if(gr_grp.get('name', usr_rec.group.name))
gr_grp.u_group_manager = gr_grp.u_group_manager + ',' + usr_rec.user;

gr_grp.update();

}

}

[Vdimri]

Hi Ankur ,

Can you please let me know how can I add multiple users in one single group , kindly let me know? where should I write this script as I'm new to ServiceNow  . Is it before BR I've to use. 

[Harsha M V]

@Ankur Bawiskar , Thank you very very much It worked.
I have marked as helpful and accepted the solution.

Keep helping and keep inspiring others.
Thank You so much