7.2 Utilisation

A CRON job is run (see Rob where and when this runs) which populates the reports.infinera_utilisation table.

Using Heidi-SQL run the following query:

select b.circuit_absid,a.circuit_id, round(avg(((a.rx_octets*8)/900)),2) as avg_utilisation_in, round(avg(((a.tx_octets*8)/900)),2) as avg_utilisation_out, round(max(((a.rx_octets*8)/900)),2) as peak_in, round(max(((a.tx_octets*8)/900)),2) as peak_out

from reports.infinera_utilisation a

left join reports.opsdb_circuit b on (b.circuit_id = a.circuit_id)

where year(a.timestamp) = 2017

and month(a.timestamp) = 2

and b.status = 'Operational'

group by circuit_id;