Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > Nodes report showing downtime in minutes during the last 30 days

Nodes report showing downtime in minutes during the last 30 days

Table of contents
Created by Charmaine.Picart, last modified by Rodim Suarez on Mar 07, 2017

Views: 907 Votes: 1 Revisions: 4

Overview

This article shows the custom query for generating a report for nodes downtime in minutes.

Environment

All Orion versions

Detail

Group_Position="Beginning" SQL="SELECT MAX(VendorIcon) AS VendorIcon,  MAX(Caption) AS Caption,  MAX(StatusLED) AS StatusLED, NodeID, SUM(OutageDurationInMinutes) AS SumOutageDurationInMinutes  FROM (
    SELECT
    Nodes.VendorIcon,
    Nodes.Caption,
    Nodes.StatusLED,
    Nodes.NodeID,
    StartTime.Message, 
    StartTime.EventTime AS DownEventTime,
    (
        SELECT TOP 1 EventTime
        FROM Events AS EndTimeTable
        where EndTimeTable.EventTime >= StartTime.EventTime
            AND EndTimeTable.EventType = 5
            AND EndTimeTable.NetObjectType = 'N'
            AND EndTimeTable.NetworkNode = StartTime.NetworkNode
            AND EventTime IS NOT NULL
        ORDER BY EndTimeTable.EventTime
    ) AS UpEventTime,
    DATEDIFF(Mi, StartTime.EventTime,(
            SELECT TOP 1 EventTime FROM Events AS Endtime
            where EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5 AND EndTime.NetObjectType = 'N'
                AND EndTime.NetworkNode = StartTime.NetworkNode  ORDER BY EndTime.EventTime)
        ) AS OutageDurationInMinutes
    FROM Events StartTime 
    INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
    WHERE (StartTime.EventType = 1)
) AS UpTimeTable
where outageDurationInMinutes IS NOT NULL
GROUP BY NodeID
ORDER BY Caption ASC

See the Node downtime reports post in Thwack for more information.

 

Last modified

Tags

Classifications

Public