Network Down Time Report

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

@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.

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

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

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.

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

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.

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