Trying to make a report based on All Alerts

ImNishat

Hi Team,

Greetings!

I am looking to create a report that shows all the active alerts triggered in our solarwinds environment, as well as the details of acknowledged alerts and the users who acknowledged them.

We need this report on a monthly basis in order to track the number of alerts and acknowledgments each month. Specifically, we need data from January 2024 to June 2024.

We have NTA, NPM, and APE & MPE.

Solarwinds Version is:2024.2.0

Thanks in Advance

SteveK

So maybe something like this, unfortunately no one really acknowledges alerts in my environment.  So I can't really tell if that part works (it is the [AS] items).  I based it off of a resolved over the past month widget I had, so sorry if something seems off.

Select [AO].AlertConfigurations.Name
    , '/Orion/NetPerfMon/ActiveALertDetails.aspx?NetObject=AAT:' + ToString([AO].AlertObjectID) As AlertDetailURL
    , [AO].AlertConfigurations.Severity
    , [AO].EntityCaption
    , [AO].EntityDetailsUrl
    , CASE [AO].EntityType
            When 'Orion.Nodes' then '[Self]'
            Else [AO].RelatedNodeCaption
        End As RelatedNodeCaption
    , [AO].RelatedNodeDetailsUrl
    , ToLocal([AO].AlertHistory.TimeStamp) as TriggerTime
    , ToLocal([TH].TimeStamp) as ResolvedTime
    , [AS].Acknowledged
    , [AS].AcknowledgedBy
    , ToLocal([AS].AcknowledgedTime) as AcknowledgedTime
From Orion.AlertObjects [AO]
    Left Outer Join (
            SELECT [H].AlertHistoryID
                , [H].AlertActiveID
                , [H].AlertObjectID
                , [H].TimeStamp
            From Orion.AlertHistory [H]
            Where [H].EventType = 1
        ) as [TH] on [AO].AlertHistory.AlertActiveID = [TH].AlertActiveID
    Left OUter Join Orion.AlertStatus [AS]
        on [AO].AlertHistory.AlertObjectID = [AS].AlertObjectID
Where [AO].AlertHistory.TimeStamp > AddMonth(-1,GetDate())
        And [AO].AlertHistory.EventType = 0