Submit a ticketCall us
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: 1,221 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