Remove the inactive members

[siri27]

In the group many of them are inactive, so two things to be done:
1. Remove the inactive members by running a fix script to fix the existing data
2. Fix the code which removes the inactive members from the group.

How to write fix script to remove the inactive members from the group.

[RaghavSh]

This code will remove inactive members from groups in fix script:

var usr = new GlideRecord('sys_user_grmember');
usr.addEncodedQuery('user.active=false');
usr.query();
while(usr.next())
{
usr.deleteRecord();
}

[Gunjan Kiratkar]

Hi @siri27 ,

You can use below code to remove inactive user from group.

var grpMember = new GlideRecord('sys_user_grmember');
grpMember.query();
while (ggrpMember.next()) {
    var gr = new GlideRecord('sys_user');
    gr.addEncodedQuery('active=false^sys_id=' +grpMember.user); // 
        gr.query();
        if (gr.next()) {
            grpMember.deleteRecord();
        }

    }

[vikrantsharma]

These scripts would help, however from an audit purpose, you shouldn't delete user records and it might trigger cascade deletion of the user references on the tickets. It is also a good practice for Audit purposes to keep the user and deactivate them.

Keep the user records, delete the group membership record.