Notification for deleted records

shivani42
Tera Contributor

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.

shivani42_0-1755603193275.png

 

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

 

11 REPLIES 11

Hello @shivani42 , Did you get a chance to look into my detailed solution. Could you please mark it as the solution if the same was followed?

Hello @shivani42  A gentle nudge, did you get a chance to look into my detailed solution?