cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Network Down Time Report

Hello Everyone,

I am trying to generate downtime report for nodes with Down status only , but issue is that report shows me Warning, Critical and other status also which I don't want. Secondly I couldn't find option to generate report for a specific time period like (report for specific Month , Week or Day)

Downtime Report.PNG

This is solarwind web based report and I had used dynamic query builder to filter status field to show me only down status

Status.PNG

Tags (1)
0 Kudos
5 Replies
Level 15

There was a similar report in the legacy Report Writer. You could edit the query below to include the time you are interested in.

This was the Node Availability - Last Month chart

SELECT  TOP 10000 CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
Nodes.NodeID AS NodeID,
Nodes.VendorIcon AS Vendor_Icon,
Nodes.Caption AS NodeName,
Nodes.IP_Address AS IP_Address,
AVG(DailyNodeAvailability.Availability) AS AVERAGE_of_Availability

FROM
Nodes INNER JOIN DailyNodeAvailability ON (Nodes.NodeID = DailyNodeAvailability.NodeID)


WHERE
( DateTime BETWEEN 43798 AND 43828.9999884259 )

GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.NodeID, Nodes.VendorIcon, Nodes.Caption, Nodes.IP_Address


ORDER BY SummaryMonth ASC, 4 ASC

0 Kudos

@bobmarely thanks a ton for your help

Actually I just want to see down status on node in my above mention report but it is showing me Warning, Critical and other status which I don't want to see. I just want to see Down status in my above report.

0 Kudos
Level 15

If you put this into SWSQL into a report. It will show you all of the currently down nodes and the time they went down.

SELECT

    NodeName AS [Node Name],

        '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],

        DetailsUrl AS [_LinkFor_Node Name],

        MAX(DOWNEVENT.EVENTTIME) AS [DOWN TIME]

FROM ORION.NODES NODES

INNER JOIN ORION.EVENTS DOWNEVENT

ON NODES.NODEID = DOWNEVENT.NETWORKNODE

WHERE STATUS = 2

GROUP BY NodeName, StatusIcon, DetailsUrl, Nodes.CustomProperties._Group

ORDER BY NodeName

0 Kudos

bobmarley​ Again thank you so much! but when I used above query into SWSQL report it is giving me error  *Query is not valid

0 Kudos
Level 15

Sorry, pull this off the above query - Nodes.CustomProperties._Group

I have a Custom Property defined in my environment called _Group.

The one below should work and look like this.

pastedImage_0.png

SELECT

    NodeName AS [Node Name],

        '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],

        DetailsUrl AS [_LinkFor_Node Name],

        MAX(DOWNEVENT.EVENTTIME) AS [DOWN TIME]

FROM ORION.NODES NODES

INNER JOIN ORION.EVENTS DOWNEVENT

ON NODES.NODEID = DOWNEVENT.NETWORKNODE

WHERE STATUS = 2

GROUP BY NodeName, StatusIcon, DetailsUrl

ORDER BY NodeName