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

    Adding Availablity information to Historical node status

    bgrade

      Hi,

       

        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

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


      WHERE
      ( EventTime BETWEEN 40616 AND 40623 )
       AND 
      (
        (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?

       

      Thanks

       

      Tom