I am looking to get some sql together to give us a list of all the active alerts that are triggering during the course of a day.
We are currently receiving more than 1000 email alerts a day and I need to get these alerts into an excel format do we can review these to confirm whether they are relevant.
Any ideas on how to achieve this?
Try this out:
SELECT A.AlertName, A.AlertDescription, AD.Title, AD.Target FROM AlertDefinitions A
FULL JOIN ActionDefinitions AD ON A.AlertDefID = AD.AlertDefID
A.Enabled = 1 AND AD.ActionType = 'EMail'
ORDER BY A.AlertName ASC