Inactive User Removal from Notification table

[Gayathry]

Hi Team,

We have to remove the inactive users from Notifications(sysevent_email_action) table if multiple users are receiving the notification email (applicable for non-event triggered emails). And if email notification (applicable for non-event triggered emails) is getting sent just to inactive user, then have to remove the inactive user from 'Users' field and make the entire notification as inactive.

We have to implement this requirement using scheduled job. Could you please help me with the script for implementing this scenario.

Thank you!

[Sohail Khilji]

Hi @Gayathry ,

Here is the solution which you can adjust as per your requirement. 

https://www.servicenow.com/community/developer-forum/remove-inactive-users-from-tables/td-p/2653884

I hope this help.......