Fix script to delete roles, groups assigned to existing user who is inactive.

[Kavya Policepa1]

I want Fix script to delete roles, groups assigned to existing user who is inactive in sys_user table.

[Mohith Devatte · Accepted solution]

hello @Kavya Policepatil ,

try this 

var inusr = new GlideRecord('sys_user');
inusr.addQuery('active','false');
inusr.query();
while(inusr.next())
{
var role = new GlideRecord('sys_user_has_role');
role.addQuery('user',inusr.sys_id);
role.query();
while(role.next())
{
role.deleteRecord();
}
var group = new GlideRecord('sys_user_grmember');
group.addQuery('user',inusr.sys_id);
group.query();
while(group.next())
{
group.deleteRecord();
}

}

But usually once you make a person in active in user table automatically he /she will be removed from the groups table .

But yeah give it a try 

please mark my answer correct if it helps you

[SumanthDosapati]

group.deleteRecord()

semi colon missing 🙂

Regards,
Sumanth

[Mohith Devatte]

yep ! thanks sumanth edited it 

[Kavya Policepa1]

Thank you.