Thwack » SolarWinds » Orion Network Performance Monitor » Reports measuring past acknowledgement time

in More Search Options

Reports measuring past acknowledgement time

Last post 08-01-2007 5:45 PM by ktucker. 0 replies.
Page 1 of 1 (1 items)
Sort Posts:

  • 08-01-2007 5:45 PM

    • ktucker
    • Top 200 Contributor
      •
    • Joined on 11-28-2005
    • Posts 37
    • Points 94

    Reports measuring past acknowledgement time

    Reply

    Hi there

    I am writing a query to link to my 24 Hour outage report. So far, I can get my list of nodes that were down and also the total length of time in minutes they were down.

    This question relates to the Advanced Alerts and does the database record past alerts as opposed active alerts?

    I am using the following to get the information before attempting to JOIN to my outage report.

    The following simple output will give the required information

    SELECT

    AlertStatus.ObjectName AS ObjectName, AlertStatus.TriggerTimeStamp AS EventStart, AlertStatus.AcknowledgedTime AS AcknowledgedTime, AlertStatus.AcknowledgedBy

    FROM
    AlertStatus

    Is there history of Active Alerts?

    Thanks

    Ken

    Regards
    Ken
    Filed under:
    • Post Points: 1
Page 1 of 1 (1 items)