How to get the user list who all are not part of any group in snow

[kamali]

Hi All,

Could someone please help me to get the user list who all are not part of any group in snow,

Thank you

[Avinash Mahato1 · Accepted solution]

Hello @kamali 

We can use this script to get your requirement

var count=0;

var dataRec=new GlideRecord("sys_user");

   dataRec.query();

while(dataRec.next()){

    var data= new GlideRecord("sys_user_grmember");

    data.addQuery("user",dataRec.sys_id);

    data.query();

  var num=data.getRowCount();

    if(num==0){

        count++

    }

}

gs.info(count);

if helpful please give me a thumbs up!!

Regards, 

Avinash

[Avinash Mahato1 · Accepted solution]

Hello @kamali 

We can use this script to get your requirement

var count=0;

var dataRec=new GlideRecord("sys_user");

   dataRec.query();

while(dataRec.next()){

    var data= new GlideRecord("sys_user_grmember");

    data.addQuery("user",dataRec.sys_id);

    data.query();

  var num=data.getRowCount();

    if(num==0){

        count++

    }

}

gs.info(count);

if helpful please give me a thumbs up!!

Regards, 

Avinash

[Nicolas Piveta · Accepted solution]

Hi, you can simply create a GlideRecord as this one.

var users = new GlideRecord('sys_user');
users.addActiveQuery();
users.query();
while(users.next()){
        var userGroup = new GlideRecord('sys_user_grmember');
        userGroup.addQuery('user', users.sys_id);
        userGroup.query();
        if(!userGroup.hasNext()){
                  gs.print(users.getDisplayValue());
        }
}

if helpful please give me a thumbs up!!

Regards, 

Nicolas.