Version 1

    I don't know about you, but I really don't like the new Active Alerts view they created in NPM 11.5, to replace the old one they had since I started using Orion NPM. It only show 5 at a time, and you cannot sort it with the latest on the top. I like to see the newest alerts at the top of that view. So I created a Custom Query view to replicate the old view. I took the SWQL code from the All+Active+Alerts.xml script in NPM 11.5 RC4 Active Alerts and modified it a little and then put it into a Custom Query and added to the Summary page.

     

    This is what it looks like:

    active alerts.jpg

    Here is the code to insert in the SWQL box:

    SELECT DISTINCT

    ToLocal(AlertActive.TriggeredDateTime) AS AlertTriggered,

    Case

      When Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/86400)>0 Then

      ToString(ToString(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) +0.0)/86400))+'d '+

      ToString(Floor(((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) - 86400*(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/86400))) + 0.0)/3600))+'h '+

      ToString(Floor(((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) - 3600*(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/3600))) + 0.0)/60))+'m ')

      When Floor(((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) - 86400*(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/86400))) + 0.0)/3600)>0 Then

      ToString(ToString(Floor(((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) - 86400*(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/86400))) + 0.0)/3600))+'h '+

      ToString(Floor(((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) - 3600*(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/3600))) + 0.0)/60))+'m ')

      When Floor(((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) - 3600*(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/3600))) + 0.0)/60)>0 Then

      ToString(ToString(Floor(((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) - 3600*(Floor((SecondDiff(AlertActive.TriggeredDateTime,GetUtcDate()) + 0.0)/3600))) + 0.0)/60))+'m ')

      Else ''

    End AS ActiveTime,

    AlertObjects.RelatedNodeCaption AS NODE, AlertObjects.EntityCaption AS ENTITY, AlertConfigurations.Name AS ALERT

     

     

    FROM Orion.AlertObjects (nolock=true) AlertObjects

    INNER JOIN Orion.AlertActive (nolock=true) AlertActive ON AlertObjects.AlertObjectID=AlertActive.AlertObjectID

    INNER JOIN Orion.AlertConfigurations (nolock=true) AlertConfigurations ON AlertConfigurations.AlertID=AlertObjects.AlertID

    ORDER BY AlertTriggered DESC, RelatedNodeCaption ASC