Is there a report listing when an alert was last triggered and how often?

Over the years we have gathered a large number of alerts. I would like to review what ones we need. Is there a way to report on when the last time each alert was triggered and how often it is triggered?

I know that an alert may be needed even if it has not been triggered in some time but any that are regularly triggered, show a common usage pattern or have gone off recently I can eliminate from my investigation.

Find more posts tagged with

Alerts

report

Accepted answers

monitoringlife

This post Report for alert frequency (last triggered) might answer your question.

SELECT
    A.Name AS [Alert Name]
    ,A.LastEdit
    ,A.CreatedBy
    ,MAX(AO.LastTriggeredDateTime) AS [Last Triggered]
FROM Orion.AlertConfigurations AS A
LEFT OUTER JOIN Orion.AlertObjects AS AO ON A.AlertID=AO.AlertID
WHERE
    A.Enabled=TRUE
GROUP BY A.Name,a.LastEdit,a.CreatedBy
ORDER BY [Last Triggered]

All comments

monitoringlife

Might get more traction in Report Lab link.

monitoringlife

This post Report for alert frequency (last triggered) might answer your question.

SELECT
    A.Name AS [Alert Name]
    ,A.LastEdit
    ,A.CreatedBy
    ,MAX(AO.LastTriggeredDateTime) AS [Last Triggered]
FROM Orion.AlertConfigurations AS A
LEFT OUTER JOIN Orion.AlertObjects AS AO ON A.AlertID=AO.AlertID
WHERE
    A.Enabled=TRUE
GROUP BY A.Name,a.LastEdit,a.CreatedBy
ORDER BY [Last Triggered]