2 Replies Latest reply on Dec 4, 2012 7:27 AM by btp

    Difference between Report Writer Preview and web page

    btp

      I have made a report to list every interface belonging to a given node type, which has had >80% traffic the last 5 days. In the report writer preview it looks right (900 records right now..), but in the web page I only get two (2) results.

       

      Another difference is that in Preview mode I get all records matching the filter, and on the web I get what it seems to be one per day.

       

       

      report.PNGrreport1.PNG

      Preview mode:

      report2.PNG

      Web page:

      report3.PNG

        • Re: Difference between Report Writer Preview and web page
          btp

          FWIW - here is the SQL:

          SELECT  TOP 10000 InterfaceTraffic.DateTime AS DateTime,
          
          Nodes.Caption AS NodeName,
          Interfaces.Caption AS Interface_Caption,
          AVG(Case InBandwidth
                      When 0 Then 0
                      Else (In_Averagebps/InBandwidth) * 100
                      End) AS AVERAGE_of_Recv_Percent_Utilization,
          AVG(Case OutBandwidth
                      When 0 Then 0
                      Else (Out_Averagebps/OutBandwidth) * 100
                      End) AS AVERAGE_of_Xmit_Percent_Utilization

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

          WHERE
          ( DateTime BETWEEN 41240 AND 41245 )
          AND
          (
            (Nodes.CustomerName = 'core') AND
            (
             (Case InBandwidth
                      When 0 Then 0
                      Else (In_Averagebps/InBandwidth) * 100
                      End >= 80) OR
             (Case OutBandwidth
                      When 0 Then 0
                      Else (Out_Averagebps/OutBandwidth) * 100
                      End >= 80))
          )
          GROUP BY InterfaceTraffic.DateTime, Nodes.Caption, Interfaces.Caption
          ORDER BY 1 ASC, 2 ASC, 3 ASC