Notification for deleted records

[shivani42]

Hi All,

I have a requirement where the records deleted from alm_entitlement_user table get notified.

For example, if below records got deleted then a notification should be sent to specific group about this.

The issue is, i was using the sys_audit_delete table to send the notification and filtered it based on table name but if the assigned user has two records in the below table and those records got deleted it is sending two seprate notifications but i want something like below.

For example assigned to shivani and has two records 

Subject - records deleted from user allocation table

user          Entitlement

Shivani     MS 365 Enterprise F3

Shivani      Zscaler agent

If anyone has any idea, you help would be appretiated.

Regards,

Shivani

[Bhuvan]

@shivani42 

Did you try email digest ?

https://www.servicenow.com/docs/bundle/zurich-platform-administration/page/administer/notification/c...

You can send consolidated email notifications based on your requirements using email digest.

If this helps to answer your query, please accept the solution and close the thread.

Thanks,

Bhuvan

[Ankur Bawiskar]

@shivani42 

Why not use before delete business rule and use gs.eventQueue() to trigger email?

But it will send 1 email per record deleted.

You can't club together the information unless you store somewhere the records which got deleted against that user.

How to Properly Send an Email Notification When a Record Is Deleted in ServiceNow 

OR

Run a scheduled job which runs daily and clubs the information from sys_audit_delete table

see below on how to send consolidated email

Email Notification to all users of assets assigned specifically to them 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@shivani42 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[shivani42]

Hi Ankur,

Thanks for the response.

I checked the link you provided, if i create a job to consolidate the data based on user. How it is possible because the records are already deleted from the user allocation table.

Regards,

Shivani