0 Replies Latest reply on Mar 11, 2009 8:22 AM by scarabeus74

    Traffic Rates report Average higher than Peak

      Hi,

      I have following problem. In Average and Peak Traffic Rates report for last month in some rows I have Average values higher than peak values what is illogical. can someone help me ?

      SQL query

      SELECT  TOP 10000 CONVERT(DateTime,
      LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
      101) AS SummaryMonth,
      Nodes.NodeID AS NodeID,
      Interfaces.InterfaceID AS InterfaceID,
      Nodes.Caption AS NodeName,
      Nodes.VendorIcon AS Vendor_Icon,
      Interfaces.Caption AS Interface_Caption,
      Interfaces.InterfaceIcon AS Interface_Icon,
      AVG(InterfaceTraffic.In_Averagebps) AS AVERAGE_of_Average_Receive_bps,
      MAX(InterfaceTraffic.In_Maxbps) AS MAX_of_Peak_Receive_bps,
      AVG(InterfaceTraffic.Out_Averagebps) AS AVERAGE_of_Average_Transmit_bps,
      MAX(InterfaceTraffic.Out_Maxbps) AS MAX_of_Peak_Transmit_bps

      FROM
      (Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID))  INNER JOIN InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID)


      WHERE
      ( DateTime BETWEEN 39843 AND 39870.9999884259 )

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


      ORDER BY SummaryMonth ASC, 4 ASC, 6 ASC

      Orion Version 9.1.0 SP 4

      Orion Report Writer Version 9.1.3

      Thanks