Hi, I am using Solarwinds Orion 9.5 SLX, I created the query for calculate the daily node downtime in minutes, This is my Query:
SELECT
VendorIcon as VendorICON,
NodeID AS NodeID,
Events.EventTime AS Event_Time,
Nodes.Caption AS NodeName,
Nodes.IP_Address,
Events.Message AS Message,
DATEDIFF(Mi, Events.EventTime, isnull(
(SELECT TOP 1
EventTime
FROM Events AS Endtime
WHERE EndTime.EventTime > Events.EventTime AND EndTime.EventType = 5
AND EndTime.NetObjectType = 'N'
AND EndTime.NetworkNode = Events.NetworkNode
ORDER BY EndTime.EventTime),getdate())) AS OutageDurationInMinutes
FROM
Nodes INNER JOIN
(Events INNER JOIN EventTypes Events_EventTypes ON
(Events.EventType = Events_EventTypes.EventType)) ON
(Nodes.NodeID = Events.NetworkNode)
WHERE
Events.EventType = 1 AND Events.NetObjectType = 'N' AND
Events.eventtime between dateadd(day, -1, getdate()) and getdate()
ORDER BY EventTime DESC
but the result of these query is different of what solarwinds show in the Home Page(Map View,
Down Nodes)
I got all "(Request Timed Out)" and "(Host Unreachable)" result in those query but I didnt get the down node that solarwinds show in the home page?!!! How Solarwinds find out one node has been down?and of course what solarwinds show is exactly the node(switch) that is off and not packet lost or anything like that.
I want to report exactly the Downtime of the nodes not the request time out or anything that casue by packet lost? how can I do that? how should I change that query?
