Active Alerts display by Host Name

You're going to want to use the Custom Query resource a few times here.

Here's one I use which someone else put up on thwack and I've edited a tad:

SELECT o.AlertConfigurations.Name AS [ALERT NAME] ,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME] ,CASE WHEN o.AlertConfigurations.Severity = 2 THEN '/Orion/images/ActiveAlerts/Critical.png' WHEN o.AlertConfigurations.Severity = 3 THEN '/Orion/images/ActiveAlerts/Serious.png' WHEN o.AlertConfigurations.Severity = 1 THEN '/Orion/images/ActiveAlerts/Warning.png' WHEN o.AlertConfigurations.Severity = 0 THEN '/Orion/images/ActiveAlerts/InformationalAlert.png' WHEN o.AlertConfigurations.Severity = 4 THEN '/Orion/images/ActiveAlerts/Notice.png' END AS [_iconfor_ALERT NAME] ,o.EntityCaption AS [ALERT OBJECT] ,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT] ,case WHEN o.RelatedNodeCaption=EntityCaption THEN 'Self' When o.RelatedNodeCaption!=EntityCaption THEN RelatedNodeCaption End as [RELATED NODE] ,o.RelatedNodeDetailsURL AS [_LinkFor_RELATED NODE] ,ToLocal(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME] ,'/Orion/images/StatusIcons/Small-' + p.StatusIcon AS [_IconFor_RELATED NODE] ,CASE when minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())>1440 then (tostring(round(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())/1440.0,1)) + ' Days') when minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())>60 then (tostring(round(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())/60.0,1)) + ' Hours') else (tostring(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())) + ' Minutes') end as [Time Active] ,aa.AcknowledgedBy ,ah.Message as [Note] From Orion.AlertActive aa join Orion.AlertObjects o on aa.alertobjectid=o.alertobjectid LEFT join Orion.Nodes p on p.nodeid=relatednodeid left join orion.alerthistory ah on ah.AlertActiveID=aa.AlertActiveID and ah.EventType in (2,3) where (YOUR FILTER HERE - EG. p.Caption like '%-DC-%') ORDER by o.AlertActive.TriggeredDateTime DESC

In addition to that query (glad to see something I posted out in the wild) you can also use the new custom tiles resource and apply a filter to the tile.

And to show something with an actual alert on it

And just to clarify, the all alerts resources are sensitive to view limitations, but only for the category of objects in the limit.  Its kind of weird how it works but if you put in a limitation based on a node property then it will only show you Node alerts with that property, but it still shows all alerts for any object that is not a node.  It's very frustrating and is actually the specific reason I created the query adam.beedell​ mentioned above, so I could have more control of what I do and don't want to include on the all alerts widget.

Feel free to upvote this feature request based on your query.  

Ah ty again for the code then!

Hi Adam,

Thank you for this SWQL query. Could you please share the same query where only alerts belonging to nodes with a specific Custom Property get displayed?

Hi Deltona,

In the

"

where (YOUR FILTER HERE - EG. p.Caption like '%-DC-%')

"

bit you could try:

"

where (p.CustomProperties.Server_application like '%YOUR APPLICATION HERE%')

"

That works just fine in my environment. Any node custom property should fit in the italic section

Thanks, that worked great!

Hi,

i'm not able to find "Custom Tile", i have the last version

[edit : seems to be renamed as "Status Summary", but i can't use it, message :

Authorization Failure

Authorization has been denied for this request.

]

I think we need to incorporate this functionality on All Active reports. We are confused on which nodes we got the application status down.