Outage report not working....

Question

I have added the following Outage report to our Orion Reports collection awhile back but noticed it isn't working and not sure why. I know I have had outages but this doesn't show me anything.

I looked at the data in the Events table and I see EventTypes of everything but a 1 so I am not sure what the 1 signifies.

I have the same report on another server on another network and it works fine.

SELECT StartTime.EventTime, Nodes.Caption, Nodes.Location,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) AND (StartTime.NetObjectType = 'N') AND month(eventtime) = month(getdate()) 
ORDER BY Nodes.Caption ASC

FormerMember · Answer

Thanks - that helps. I think my problem is that i have some devices that went down yesterday but have cleared and the 24 period might have expired.

I will keep trying to play with it.

kweise · Answer

I'm not sure how helpful this is, but I can tell you that an event of 1 signifies a node has stopped responding.  An event type of 5 indicates a node is responding again.  If you don't have any type 1 events in the events table, you won't get anything in the report.