Report for alert frequency (last triggered)

Good afternoon all those smarter than me....

I have an Orion environment that has grown over a period of 15 years. During that time we've created over 500 different alerts for various reasons. Is there an "easy" way to pull a report to see when the last time each alert fired or triggered? Hoping to clean out a bunch of old, irrelevant alerts through this exercise. Thanks again.

Dan

Find more posts tagged with

report_writer

npm

Alerting

Accepted answers

Seashore

Can this do the trick?

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]

EDIT: Added Alert last edited and created by

All comments

Seashore

Can this do the trick?

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]

EDIT: Added Alert last edited and created by

danbert

That worked....thanks.