Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 254 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
18:05, 6 Mar 2017

Tags

Classifications

Public