1 ACCEPTED SOLUTION
Here's my approach and it's working as expected.
1. Event registry:
2. Scheduled job:
var user = new GlideRecord('sys_user');
//Active users with last login time is not empty and last login time is before 60 days.
user.addEncodedQuery("active=true^last_login_timeISNOTEMPTY^last_login_timeRELATIVELT@dayofweek@ago@60");
user.query();
while (user.next()) {
//Triggering the event by passing the user record and user sys_id
gs.eventQueue('dormancy.policy.trigger', user, user.sys_id);
// Calling the function to remove user from the groups
this.removeUsersFromGroup(user);
}
// Function to remove users from the group
function removeUsersFromGroup(user_record) {
var group_membership = new GlideRecord('sys_user_grmember');
group_membership.addQuery("user", user_record.sys_id);
group_membership.deleteMultiple();
}
Notification:
Result:
I hope this helps.
