you need to create separate email notifications for each condition. This ensures that each notification is triggered and sent based on the specific criteria.
Creating Email Notifications:
Go to System Notification > Email > Notifications.
Click New
First Notification: Group member's account becomes inactive.
Name: Enter a name for the notification.
Table: Set it to User [sys_user].
When to Send: Choose the condition "when a record is updated".
Condition: Set the condition to active changes to false and member of group starts with API.
Who will receive: Choose Group Manager and Group Member.
CC: Add the CMDB team.
and script for this is
''
var user = new GlideRecord('sys_user');
user.get(current.user_id);
var group = new GlideRecord('sys_user_grmember');
group.addQuery('user', user.sys_id);
group.query();
while (group.next()) {
var groupName = group.getValue('group');
if (groupName.startsWith('API')) {
var email = new GlideEmailOutbound();
email.setSubject("Group Member Inactive");
email.setBody("The account of group member " + user.getValue('name') + " has become inactive.");
email.setTo(group.getValue('manager.email'));
email.addAddress('cc', 'cmdb_team@example.com');
email.send();
break;
}
}; ''
Second Notification: Group manager's account becomes inactive.
Name: Enter a name for the notification (e.g., "Group Manager Inactive").
Table: Set it to User [sys_user].
When to Send: Choose the condition "when a record is updated".
Condition: Set the condition to active changes to false and manager of group starts with API.
Who will receive: Choose Group Member.
CC: Add the CMDB team.
script for this is
'' var user = new GlideRecord('sys_user');
user.get(current.user_id);
var group = new GlideRecord('sys_user_grmember');
group.addQuery('manager', user.sys_id);
group.query();
while (group.next()) {
var groupName = group.getValue('group');
if (groupName.startsWith('API')) {
var email = new GlideEmailOutbound();
email.setSubject("Group Manager Inactive");
email.setBody("The account of group manager " + user.getValue('name') + " has become inactive.");
email.setTo(group.getValue('user.email'));
email.addAddress('cc', 'cmdb_team@example.com');
email.send();
break;
}
}; ''
