0 Replies Latest reply on Jun 8, 2010 6:31 PM by max2479

    Help with SQL Report Designer

    max2479

      I am designing a report using Report Designer. I am not a sql guru and would like to modify my report to display 2 more columns

      Below is the report and I would like to add Port and Protocol fields to my report. Can someone help please?

      SELECT  TOP 10000 Nodes.DNS AS DNS,
      Nodes.NodeID AS NodeID,
      Nodes.IP_Address AS IP_Address,
      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 CircuitUtil_AvgRecvXmit,
      Interfaces.MaxOutBpsToday AS MaxOutBpsToday,
      InterfaceTraffic.DateTime AS DateTime,
      Interfaces.InterfaceID AS InterfaceID

      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 40333.6659027778 AND 40335.6666666667 )
       AND 
      (
        (Nodes.DNS = 'xxxx.xxx.com') AND
        (Nodes.IP_Address = '10.20.100.10') AND
        ((NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 > 0) AND
        (Nodes.NodeID = 167) AND
        (InterfaceTraffic.DateTime > '2001-01-01')
      )

       

      ORDER BY 3 ASC, 4 ASC, 5 ASC, 6 ASC