Good afternoon!
I've created a dashboard for my DBA team, complete with Active Alerts. The problem is, the Active Alerts resource isn't showing any alerts for the team. Their group account has a "DBA" alert limitation, and the alerts show up for them when they go to the Alerts view. They do not show up in the Active Alerts resource though. I've checked "Show Acknowledged Alerts" in the resource as well.
As a resolution attempt, I tried to create a custom SWQL query resource with similar information. The query works in the SWQL Studio, but does not show anything in the custom resource.
SELECT ac.Name AS [Alert], ac.AlertMessage AS [Message], ao.EntityCaption AS [Object], ao.LastTriggeredDateTime AS [Last Triggered On], ao.RelatedNodeCaption AS [Node], ao.EntityDetailsUrl AS [_LinkFor_Object], ao.RelatedNodeDetailsUrl AS [_LinkFor_Node], 'http://rpmon.mh.connectria.com/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(ao.AlertObjectID) AS [_LinkFor_Alert]FROM Orion.AlertActive AS aaLEFT OUTER JOIN Orion.AlertObjects AS ao ON aa.AlertObjectID = ao.AlertObjectIDLEFT OUTER JOIN Orion.AlertConfigurations AS ac ON ao.AlertID = ac.AlertIDWHERE ac.Category = 'DBA'
Can anyone help?!
Thanks!
