How to get group name a particular user

Leonie1
Kilo Expert

Hi Team,

How to get group name of a particular user

Thanks.

1 ACCEPTED SOLUTION

Prins Kumar Gup
Giga Guru

Hi Prakash

use the below script

var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('user',gs.getUserID());
gr.query();
while(gr.next()){
gs.print(gr.group.name);
}

View solution in original post

3 REPLIES 3

Prins Kumar Gup
Giga Guru

Hi Prakash

use the below script

var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('user',gs.getUserID());
gr.query();
while(gr.next()){
gs.print(gr.group.name);
}

SNOW User8
Giga Guru

Hi

 

If you want to get group name of particular user then use the below

var grr = new GlideRecord('sys_user_grmember');
grr.addQuery('user', 'XXXXX'); //User Sys ID
grr.query();
while(grr.next()){
gs.print(grr.group.name);
}

 

Or

 

var grr = new GlideRecord('sys_user_grmember');
grr.addQuery('user.name', 'YYYY'); //User Name
grr.query();
while(grr.next()){
gs.print(grr.group.name);
}

This will give all the group names where the user is present in multiple groups

var members = [];
var grpMbr = new GlideRecord('sys_user_grmember');
grpMbr.addQuery('user',gs.getUserID());
grpMbr.query();
while (grpMbr.next()){
members.push(grpMbr.group.name.toString());
gs.print("HAR"+grpMbr.group.name);
}

Regards
Harish