Email sending on duplicate inserts/updates

[Sarah Bouil]

Updated/created on today & Name > 3 consecutive inserts/updates - An alert should trigger to 'development@example.com' team. Below is the screenshot. 

For example:

Name:                       Serial number:     Created/Updated:

*ASSET-IBM               L3BB911             2024-10-07 10:42:29
*ASSET-IBM               L3BB911             2024-10-07 10:42:35

this case I need to send an email

Name:                       Serial number:     Created/Updated:

*ASSET-IBM               L3BB911             2024-10-07 10:42:29
*ASSET-IBM               L3BB910             2024-10-07 10:42:35

This case I dont need to send a email as the Serial Number is different

Name:                       Serial number:     Created/Updated:

*ASSET-IBM               L3BB911             2024-10-08 10:42:29

*ASSET-EY                  L0CC255            2024-10-07 10:42:35
*ASSET-IBM               L3BB911             2024-10-06 10:42:35

This case I dont need to send a email as it is not created or updated consecutive as the other record created in between.

How to achieve this? please help me with the script.

[Uncle Rob]

Why would you care about any mix of create/update 3x in sequence vs 3x in a period but one other inserted an update before the 2nd or 3rd?

[Sarah Bouil]

It is requirement from my business team. It should send a notification if the Name > 3 consecutive inserts/updates and created on today.

[Sarah Bouil]

Please suggest how can I achieve it