1 Reply Latest reply on May 11, 2017 3:06 PM by ctlswadmin

    Help with Interface capacity reports

    sja

      Hello

       

      I need  list of interfaces that reach a capacity of over 65%

       

      I just like to see those interfaces named only ones in that report?

       

      I can not get that to work ..

       

      Tia

       

      Sja

        • Re: Help with Interface capacity reports
          ctlswadmin

          Hey sja,

           

          This query gives you interfaces that are at 65% or greater based on input/output numbers.

           

          SELECT

          n.Caption AS NodeName, i.Caption AS Interface_Caption, i.Outbps AS Xmit_bps, i.Inbps AS Recv_bps, i.OutPercentUtil AS Xmit_Percent_Utilization,

          i.InPercentUtil AS Recv_Percent_Utilization, (NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 AS AvgXmitRecvPercentUtil

          FROM

          Nodes n INNER JOIN interfaces i ON (n.NodeID = i.NodeID)

          Where (NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 >= '65'

           

          Should work on NPM 12.0 and over.