Hi @vishnumaaya
I've tried your scenario in my PDI using some sample data. It's giving the expected outpur. PFB.
1. Event registry: Table = "sys_user_has_role"
2. Notifictaion: Table = "sys_user_has_role"
3. Email Script:
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
// Add your code here
var removedUsers = event.parm1 || ''; // 'removed_users' passed in event param
var timeStamp = new GlideDateTime().getDisplayValue();
template.print('<p>The following inactive users have been removed from their assigned support groups:</p>');
template.print('<p><strong>Removed Users:</strong></p>');
template.print(removedUsers.toString().split(',').join('<br />'));
template.print('<p>This action was taken on <strong>' + timeStamp + '</strong> because these users:</p>');
template.print('<ul>' +
'<li>Have not logged in at all</li>' +
'<li>Have not logged in within the past 30 days</li>' +
'<li>Or were not recently (within the last 7 days) assigned their role</li>' +
'</ul>');
template.print('<p>Please refer to the system logs for additional details.</p>');
})(current, template, email, email_action, event);4. Background script: Make sure to modify the script as per your requirement. For testing, i just considered users with itil role and last login time is greater than last 7 days. Also add deleteRecord() method wherever required.
var arr = [];
var user_rec = new GlideRecord('sys_user_has_role');
user_rec.addEncodedQuery('user.last_login_timeRELATIVELT@dayofweek@ago@7^role=282bf1fac6112285017366cb5f867469'); // ITIL ROLE & LAST LOGIN IS GREATER THAN LAST 7 DAYS [EDIT THIS AS PER YOUR REQUIREMENT]
user_rec.query();
while (user_rec.next()) {
this.removeGrpMembership(user_rec.user.sys_id);
gs.print("User name: " + user_rec.user.name);
}
function removeGrpMembership(user_rec) {
var user_grp = new GlideRecord('sys_user_grmember');
user_grp.addEncodedQuery('user=' + user_rec); //[EDIT THIS AS PER YOUR REQUIREMENT]
user_grp.query();
while (user_grp.next()) {
arr.push(user_grp.user.name + ' (Sys ID: ' + user_grp.user.sys_id + ') from group: ' + user_grp.group.name);
//[ADD REMOVE USER LOGIC HERE]
}
}
// Trigger event if users were removed
if (arr.length > 0) {
gs.eventQueue("inactive_users_removed_even", user_rec, arr);
gs.info('RIU - Event triggered for inactive users removed');
} else {
gs.info('RIU - No users were removed');
}Output:
Regards,
Siva
