3 Replies Latest reply on Mar 12, 2014 2:19 AM by JiriPsota

    how is the average transmit and receive utilization calculated ?

    m.azeem

      I would like to know how is the average transmit in bps and receive in bps utilization calculated in the reports generated ?

       

      appreciate if someone can provide the formula used for the same

        • Re: how is the average transmit and receive utilization calculated ?
          JiriPsota

          Create new report  in Report Writer-Select Fields you are looking for. Then select "Show SQL" from menu Report.

            • Re: how is the average transmit and receive utilization calculated ?
              m.azeem

              Thanks for the info provided ...

               

              however what i wanted to know how the average itself is calculated.

               

              what i mean is how is the avg receive or avg transmit in bps calculated by orion for any interface for lets say 1 hour or 1 day, week, or month ...

               

              i hope i have been able to put forward my question properly.

                • Re: how is the average transmit and receive utilization calculated ?
                  JiriPsota

                  Last 7 days summarized by Date:

                   

                  SELECT  Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate,

                  Nodes.Caption AS NodeName,

                  Interfaces.Caption AS Interface_Caption,

                  AVG(Case OutBandwidth

                              When 0 Then 0

                              Else (Out_Averagebps/OutBandwidth) * 100

                              End) AS AVERAGE_of_Xmit_Percent_Utilization,

                  AVG(Case InBandwidth

                              When 0 Then 0

                              Else (In_Averagebps/InBandwidth) * 100

                              End) AS AVERAGE_of_Recv_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 41701 AND 41708.375 )

                  GROUP BY Convert(DateTime,Floor(Cast((DateTime) as Float)),0),

                  Nodes.Caption, Interfaces.Caption

                  ORDER BY SummaryDate ASC, 2 ASC, 3 ASC