Hello Fellow Solarwinds users! I have a good question that I hope I can get some help on! I am trying to run an advanced SQL report to show a time period of DownTime for certain nodes. I can find on thwack where someone can do a month, but I cannot figure out how to make it 6 months and thats what I need in the most desperate way! Can anyone look at this working 30 day report and help me make it 6 months?
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 NodeID = '20714' AND (StartTime.NetObjectType = 'N') AND
eventtime between dateadd(month, -1, getdate()) and getdate()
ORDER BY Nodes.Caption ASC
Please let me know if you can help!
Thank you!