How to filter active directory group from sys_user table?

[Lisa Goldman]

Hello,

We would like to see only the users that are in specific Active Directory Group from Catalog Item variable Request For.

It is possible to filter the active directory group from sys_user table?  Please advise!  Thank you

[MrMuhammad]

@Lisa Goldman - yes that's possible. In the advance reference qualifier of Requested for field/variable please use below script.

javascript: var userArray = []; var groupMemberGr = new GlideRecord("sys_user_grmember");
groupMemberGr.addQuery("group.name",  "G_SECURITY");
groupMemberGr.query();

while(groupMemberGr.next()){
    userArray.push(groupMemberGr.getValue('user'));
}

'sys_idIN'+userArray.join(',');

Hope that helps!

[Majji Koteswara]

Hi,

You can add those members here.

Hope it helps.

Regards,

Majji Koteswara Rao

[Lisa Goldman]

Sorry for the late reply, because I was out sick.  I thought about doing that Majji. However, by doing that, we have to continually change the condition if there is changes, which I think is not efficient.  Any other suggestions.  Thank you