How do you use cloud databases? Take the survey.
Options
Can you extract the alerts that are sent in email from the monitor database.
Jreed
Posts: 3 New member
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.
Tagged:
Answers
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.