Script to remove users from inactive group as I can see them in Group member table?

[Anmol12]

I want the fix script to remove the users from the inactive groups.

[BharathChintala]

@Anmol12 

var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group.active', false);
gr.qurery();
gr.deleteMultiple();

Thanks

Bharath 

[Omkar Ranjane]

Hi @Anmol12 

Try below code snippet.

var removeGrpMem = new GlideRecord('sys_user_grmember');
removeGrpMem.addEncodedQuery('group.active=false');
removeGrpMem.query();

// Method 1 : To delete multiple record
removeGrpMem.deleteMultiple();

// Method 2 : To delete rcord one by one
if(removeGrpMem.next()){
    removeGrpMem.deleteRecord();
}

If your question is solved, please close the topic by marking my answer "Accept as Solution". This will help others searching for a similar question and will remove the topic from the unsolved list.

[Namrata Ghorpad · Accepted solution]

Hello,

Write code like below.

var grp=new GlideRecord('sys_user_group');
grp.addQuery('active',false);
grp.query();
if(grp.next())
{
sid=grp.getValue('sys_id');
var groupmem=new GlideRecord('sys_user_grmember');
groupmem.addQuery('group',sid);
groupmem.query();
while(groupmem.next())
{
groupmem.deleteRecord();

}
}

Please mark my answer as helpful/correct if it helps you.

Regards,

Namrata