Alert Manager to Action Manager Relationships...

Daran

Hi,
are there any utilities available that will provide a list of Alert Managers to Action Manager relationships - i.e. we have 460 Alert Managers defined, and 998 ACtion Managers - some of these are "out of the box" and some we have written ourselves.

I would like to know which alerts are in use and by what... without having to look at every one individually.

Is there a way to see how many times each have been "fired" ?

thanks,

Daran.

bobmarley

I got this from Thwack somewhere. It lists the alerts and actions. 

SELECT
       TOLOCAL ([AH].TimeStamp) as Timestamp
     , [AH].AlertObjects.AlertConfigurations.Name AS [Alert Name]
     , [AH].AlertObjects.EntityCaption AS [Element]
     , [A].ActionTypeID AS [Action]
     , [A].Description AS [Details]
     , [AH].Message AS [Results]
FROM Orion.AlertHistory AS [AH]
INNER JOIN Orion.Actions AS [A]
  ON [AH].ActionID = [A].ActionID
WHERE [AH].TimeStamp >= GETUTCDATE() - 30 --And [AH].AlertObjects.AlertConfigurations.Name LIKE '%0554%' --AND [A].ActionTypeID LIKE '%email%'
ORDER BY [AH].TimeStamp DESC