This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Showing only acknowledged alerts in Seperate resource

how to show acknowledged alerts in seperate resource .only acknowledged alerts not all of them .when someone click acknowledge then it goes to that resource ....

in other words creating resource for only acknowledged alerts .thnx

  • The active alerts resource doesn't support filtering and I can't think of a way to even limit the view of a page to only acknowledged alerts. This will likely need to be a feature request.

  • you can create a advanced sql report to pull acknowledged alerts and use the same in your view

  • I have a resource that displays just the acknowledged alerts; here is the crazy SWQL that creates it for me and a screenshot of mine; hope this helps!

    pastedImage_0.png

    SELECT DISTINCT 

    AlertObjects.RelatedNodeCaption AS [Device],

    alertObjects.EntityCaption AS [Alert Object],

    AlertConfigurations.Name as [Alert],

    AlertObjects.RelatedNodeDetailsUrl as [_LinkFor_Device],

    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

    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

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

    WHERE AlertStatus.Acknowledged = true

    Order By AlertActive.TriggeredDateTime DESC