Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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: 431 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