Customize Availability Report that would show DownTime and Uptime of Nodes and its Interface in minutes

Hello,

Good day.

Anyone who could help to create or customize an " availability " report that would show the sum of uptime and downtime of nodes and its interface per month in minutes?

Appreciate if someone could help me on this.

Thank you.

Kind Regards,

Leny

Find more posts tagged with

network_monitoring

sql

network_management

custom_report

report

Accepted answers

All comments

bhavesh2903

SELECT

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 UpEventTime,

Nodes.Caption, StartTime.Message, 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)

ORDER BY eventtime desc

hanusek

Thank You for a great report script. I'm not familiar with SQL scripting, so I want to ask, if is possible to make a change to view downtime for nodes in Last month instead last 30 days?

LadaVarga

Hello

there is no date limitations. There is 30 days retention time for Events. Can be changed in Polling settings:

Events Retention

days

Network events will be deleted from the database after configured days.

hanusek

Hello, You are right. Thanks for suggestion.