0 Replies Latest reply on Mar 22, 2011 11:07 PM by bgrade

    Adding Availablity information to Historical node status




        I have built a report that lists the number of times a node dropped in the last 7 days. I would like to add the availability for that time period as well.


      Here is my SQL


      SELECT TOP 10
      Nodes.StatusLED AS Status_Icon,
      Nodes.NodeID AS NodeID,
      Nodes.Caption AS NodeName,
      Nodes.Priority AS Priority,
      COUNT(Events.EventType) AS COUNT_of_Event_Type,
      Nodes.Caseref AS Caseref,
      Nodes.Client_Friendly_Name AS Client_Friendly_Name

      Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)

      ( EventTime BETWEEN 40616 AND 40623 )
        (Events.EventType = 1) AND

      GROUP BY Nodes.StatusLED, Nodes.NodeID, Nodes.Caption, Nodes.Priority, Nodes.Caseref, Nodes.Client_Friendly_Name

      ORDER BY 4 ASC, 5 DESC


      Is anyone able to point me in the right direction?