0 Replies Latest reply on Feb 9, 2016 5:32 PM by ccraddock@opus

    Report Writer Issue

    ccraddock@opus

      Community,

       

      I am new to the community as well as green to Solarwinds NPM. I have created a report in the report writer, but when i run the report in the report writer and then run the same report in the web console, the values returned from the web console report are wildly different than those returned via the report writer. Can someone point me in the right direction as to why this is? Ive included the SQL for completeness. Thanks.

       

       

      SELECT  TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate,
      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,
      MAX(Case InBandwidth
                  When 0 Then 0
                  Else (In_Averagebps/InBandwidth) * 100
                  End) AS MAX_of_Recv_Percent_Utilization,
      MAX(Case OutBandwidth
                  When 0 Then 0
                  Else (Out_Averagebps/OutBandwidth) * 100
                  End) AS MAX_of_Xmit_Percent_Utilization,
      AVG(Case
                  When InBandwidth+OutBandwidth=0 Then 0
                  When InBandwidth=0 Then
                  (Out_Averagebps/OutBandwidth) * 100
                  When OutBandwidth=0 Then
                  (In_Averagebps/InBandwidth) * 100
                  Else
                  ( (Out_AverageBps/OutBandwidth)+(In_AverageBps/InBandwidth))*50
                  End) AS AVERAGE_of_CircuitUtil_AvgRecvXmit

      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 42399 AND 42408 )
      AND 
      (
        (Nodes.Vendor = 'Cisco') AND
        (Interfaces.InterfaceTypeName LIKE '%PPP%')
      )

      GROUP BY Convert(DateTime,Floor(Cast((DateTime) as Float)),0),
      Nodes.NodeID, Interfaces.InterfaceID, Nodes.Caption, Nodes.VendorIcon, Interfaces.Caption, Interfaces.InterfaceIcon

      ORDER BY SummaryDate ASC, 4 ASC, 6 ASC