Remove inactive users from Group

[Sakshi Shukla]

How can we remove users from a group if they have been inactive for a specific period, such as 2 weeks?

[palanikumar]

Hi,

You can create a schedule job that get all users who are inactive and last updated is more than two weeks.

Then query sys_user_grmember table and get all record where user field has sys_id of the user received in previous step.

Delete the sys_user_grmember record.

[Rushi Savarkar · Accepted solution]

Hello @Sakshi Shukla 
You can try below scheduled job code:

(function executeScheduleJob() {
    var twoWeeksAgo = new GlideDateTime();
    twoWeeksAgo.addDaysUTC(-14);

    var inactiveUsers = new GlideRecord('sys_user');
    inactiveUsers.addQuery('active', false);
    inactiveUsers.addQuery('sys_updated_on', '<=', twoWeeksAgo);
    inactiveUsers.query();
    gs.info('count' + inactiveUsers.getRowCount());
    while (inactiveUsers.next()) {
        var groupMemberships = new GlideRecord('sys_user_grmember');
        groupMemberships.addQuery('user', inactiveUsers.sys_id);
        groupMemberships.query();
       while (groupMemberships.next()) {
            groupMemberships.deleteRecord();
        }
    }
})();

Let me know if the above code works for you.

Thank you!

[Sakshi Shukla]

Thanks for the solution , I will try and let you know.

[Sakshi Shukla]

Thank you Rushi for your soultion. It is working as expected.