Can you extract the alerts that are sent in email from the monitor database.

Jreed

I have been asked for a custom report type notification to show how many deadlocks and blocking going on for a 24 hour period instead of going through each email to extract the data.

chrisqtran

Hi @Jreed,

You can actually create a report that details a list of alerts that you've received as you can read in more detail below:
https://documentation.red-gate.com/sm/reports/creating-configuring-and-downloading-reports

​

Let me know if this works for you.