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

Parents
  • 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 emoticons_happy.png

    Actually I just want to see down status on node in my above mention report emoticons_confused.png 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

Reply Children
  • 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