I have to remove roles and group when user profile is not active.

[niveditakumari]

Hi, 

I have to remove roles and group when user profile is not active. 

Can anyone please help me to achieve that. 

Regards, 

Nivedita 

[shyamkumar VK]

@niveditakumari , here is the Solution , First Try in Lower Instance 

https://www.servicenow.com/community/developer-forum/how-to-remove-roles-and-groups-for-inactive-use...

Regards,

Shyamkumar

[chetanb]

Hello @niveditakumari 

You can check below threads which satisfies your requirement.

https://www.servicenow.com/community/developer-forum/automatic-removal-of-non-active-users-from-grou...

https://www.servicenow.com/community/itsm-forum/how-to-automatically-remove-a-user-who-is-inactive-f...

https://www.servicenow.com/community/developer-forum/how-to-remove-groups-from-user-profile-if-last-...

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Regards,

CB

[Harish KM · Accepted solution]

Hi @niveditakumari roles are always tied to group. There are 2 ways to do this

1. using flow designer , no code required, trigger will be when active is false

2. using after update BR,

Cond: active is false

script:

var user = new GlideRecord('sys_user');
user.addQuery('active', false);
user.query();
while (user.next()) {
// Remove groups
var grp = new GlideRecord('sys_user_grmember');
grp.addQuery('user.sys_id', user.sys_id);
grp.query();
while (grp.next()) {
grp.deleteMultiple();
}
}

[niveditakumari]

HI @Harish KM, 

Thank you so much for your help. 

It is working now. 

Regards, 

Nivedita