quesion on script

[Srini19]

    var gm = new GlideRecord('sys_user_group');

    gm.addQuery('active', true);

    gm.query();

    while (gm.next()) {

        var gr = new GlideRecord('sys_user_grmember');

        gr.addQuery('group.name', gm.name);

        gr.addQuery('user.name', '=', "");

        gr.query();

        if (gr.next()) {

            gs.print("This group has no member----" + gm.name);

        }

    }

This query is  working fine, how do I wirte this in addEncoded query when I tried I was getting error. Please advise.

[Me Being Mustaq]

Hi @Srini19 ,

var gr = new GlideRecord('sys_user_group');
gr.addEncodedQuery('active=true^sys_idNOT INsys_user_grmember.group');
gr.query();
while (gr.next()) {
    gs.print("This group has no member----" + gr.name);
}

• active=true ensures you are only checking active groups.

• sys_idNOT INsys_user_grmember.group means you are selecting groups whose sys_id does not exist in the group field of any sys_user_grmember record, i.e., groups with no members.

Please appreciate my efforts, help and support extended to you by clicking on – “Accept as Solution”; button under my answer. It will motivate me to help others as well.

Thanks & Regards,

Mohammed Mustaq Shaik

[Ankur Bawiskar]

@Me Being Mustaq 

are you sure this script will work?

It would be nice if you could share a working example with output so that it helps other members.

[Me Being Mustaq]

Hi @Ankur Bawiskar ,

I have executed in my PDI i got the output like

Correct me if i am wrong Ankur i will correct it, Thanks

Warm Regards,

Shaik Mustaq.