how to check if user is a member in particular group, With sysid of user .

[deepak45]

how to check if user is a member in particular group, With sysid of user .

[Balaji Jagannat]

Refer this thread here - https://community.servicenow.com/community?id=community_question&sys_id=18e01ba9dbdcdbc01dcaf3231f96...

[MrMuhammad · Accepted solution]

Hi Deepak,

If you want to check on Server side i.e Business rule, background script, scheduled job etc. then here is the script.

var gr = new GlideRecord('sys_user_grmember'); // Table stores the mapping of user and group.
gr.addQuery('user', '<sys_id_user>'); // replace <sys_id_user> with actual sys_id of user.
gr.addQuery('group', '<sys_id_group>');// replace <sys_id_group> with actual sys_id of group.
gr.query();

if(gr.next()){
  gs.info("User is Member of Group!");
}
else{
  gs.info("User is Not a Member of Group!");
}

Please mark this correct & helpful if it answered your question.

Thanks & Regards,
Sharjeel

[Dhananjay Pawar]

Hi Muhammad,

we don't have sys_gr_member such table. it should be sys_user_grmember.

Have a great day.

Thanks,

Dhananjay.

[MrMuhammad]

Hi Dhanajay,

Thank you for pointing out. It was a typo. Script is updated!

Have a great day too 🙂 

Thanks & Regards,

Sharjeel