How to query Group Members if I have the group's sys_id and how to query Group info when I have the user's sys_id?

[anchor]

How to query Group Members if I have the group's sys_id and how to query Group info when I have the user's sys_id?

[Maniraj Jayaraj · Accepted solution]

Hi,

user and group both are related with "sys_user_grmember" table. so you can retrieve both one value using other one.

//when you have group sys_id value - to get group member

var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group',<sys_id of the group goes here>);
gr.query();
while(gr.next())
{

gr.user //each group member
}



//when you have group member value - to get associated groups


var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('user',<sys_id of the user goes here>);
gr.query();
while(gr.next())
{
gr.group //each group associated with user
}

[Ankit P]

Hi,

Please use below script to get Group members: You can remove, getDisplayValue() if you need sys_ids instead of names.

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('group', 'group sys_id');

gr.query();

while(gr.next()){

gs.print(gr.user.getDisplayValue());

}

And below script to get the groups:

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('user', 'user sys_id');

gr.query();

while(gr.next()){

gs.print(gr.group.getDisplayValue());

}