how is the average transmit and receive utilization calculated ?

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

Find more posts tagged with

network_monitoring

network_management

Accepted answers

All comments

JiriPsota

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

FormerMember

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.

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