Adding SYS_IDs of the group members to an array using the sys_user_grmember table.

[moni170]

I'm tring to add the sys_id's of all the members of a particular group to an array. I've written the code for the same but somehow it's only printing the sys_id of the last pushed record. I'm adding the SS of the code and output.

Any solution??

background script code:

var memberSysIDs = [];

var members = new GlideRecord("sys_user_grmember"); members.addQuery("group",'b85d44954a3623120004689b2d5dd60a');

members.query();

while(members.next())

{

memberSysIDs.push(members.user);

}

gs.print(memberSysIDs.join(","));

Output:

*** Script: ee826bf03710200044e0bfc8bcbe5de6,ee826bf03710200044e0bfc8bcbe5de6,ee826bf03710200044e0bfc8bcbe5de6,ee826bf03710200044e0bfc8bcbe5de6,ee826bf03710200044e0bfc8bcbe5de6,ee826bf03710200044e0bfc8bcbe5de6,ee826bf03710200044e0bfc8bcbe5de6

[Jaspal Singh · Accepted solution]

Try below.

var memberSysIDs = []; 
var members = new GlideRecord("sys_user_grmember"); 
members.addQuery("group",'b85d44954a3623120004689b2d5dd60a'); 
members.query(); 
while(members.next()) 
{ memberSysIDs.push(members.user.toString());  //all you need is toString()
}
gs.print(memberSysIDs.join(",")); 

[Anurag Tripathi · Accepted solution]

Try this

var memberSysIDs = [];
var members = new GlideRecord("sys_user_grmember"); 
members.addQuery("group",'b85d44954a3623120004689b2d5dd60a'); 
members.query();
 while(members.next()) { 
memberSysIDs.push(''+members.user);
 } 
gs.print(memberSysIDs.join(",")); 

[Jaspal Singh · Accepted solution]

Try below.

var memberSysIDs = []; 
var members = new GlideRecord("sys_user_grmember"); 
members.addQuery("group",'b85d44954a3623120004689b2d5dd60a'); 
members.query(); 
while(members.next()) 
{ memberSysIDs.push(members.user.toString());  //all you need is toString()
}
gs.print(memberSysIDs.join(",")); 

[Anurag Tripathi · Accepted solution]

Try this

var memberSysIDs = [];
var members = new GlideRecord("sys_user_grmember"); 
members.addQuery("group",'b85d44954a3623120004689b2d5dd60a'); 
members.query();
 while(members.next()) { 
memberSysIDs.push(''+members.user);
 } 
gs.print(memberSysIDs.join(",")); 

[Vishal Birajdar · Accepted solution]

Hi @moni170 

Can you try like below : 

 var memberSysIDs =[];
var members = new GlideRecord("sys_user_grmember"); 
members.addQuery("group",'b85d44954a3623120004689b2d5dd60a');
members.query(); 
while(members.next()) { 
   
    memberSysIDs.push(members.user.sys_id);    //updated
    }

gs.print(memberSysIDs);