Down Time - Up Time For All Nodes

Question

Hello,

Kinda new to SolarWinds Reporting and looking for guidance.

I have around 1600 nodes that we monitor and I was asked to work on a report to show;

Hostname, IP, City, Down Time (TimeStamp), Up Time (TImeStamp) and Outage Duration.

I tried a few things but unable to accomplish this.Our intention is to see when a node went down and what time it came back online so we can understand how many minutes/hours it was non-functional.

naveensingh43 · Answer

thanks for correcting

romeo-donca · Answer

Hi

DATEDIFF function is not a SWQL function

Use

minutediff(n,d)

for more details

https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions

Your script is Ok only for one pair of down/up event per node in a specific time period

naveensingh43 · Answer

City should custom property.

Please try below SWQL Query. Hope it will help you

SELECT

n.Caption AS Hostname,

n.IPAddress AS IP_Address,

n.CustomProperties.City AS City,

eDown.EventTime AS Down_Time,

eUp.EventTime AS Up_Time,

DATEDIFF(MINUTE, eDown.EventTime, eUp.EventTime) AS Outage_Duration_Minutes

FROM Orion.Events eDown

JOIN Orion.Nodes n ON eDown.NetObjectID = n.NodeID

JOIN Orion.Events eUp ON eUp.NetObjectID = n.NodeID

WHERE

eDown.EventType = 1 -- Node Down

AND eUp.EventType = 5 -- Node Up

AND eUp.EventTime > eDown.EventTime

ORDER BY eDown.EventTime DESC