Alert actions that are failing SWQL Query

bobmarley

Needed to look into what alert actions were failing. This shows what failed over the last 7 days. You can make it into a report if you wish.

Here is the SWQL query.

SELECT 
       [History].AlertObjects.AlertConfigurations.DisplayName
     , [History].AlertObjects.AlertConfigurations.AlertMessage
     , [History].AlertObjects.EntityCaption
--     , [History].AlertObjects.EntityDetailsUrl
--     , [History].EventType
     , [Actions].Description
     , [History].Message
     , TOLOCAL ([History].TimeStamp) AS TimeStamp
FROM Orion.AlertHistory AS [History]
LEFT JOIN Orion.Actions AS [Actions]
     ON [History].ActionID = [Actions].ActionID
Where Message like '%ErrorMessage%' AND daydiff([History].TimeStamp ,getdate()) < 7 
ORDER BY [History].TimeStamp DESC