Hello Everyone,

 

I want to pull interface utilization metrics from mysql DB and make it a daily report.

Got bunch devices I am interested in, each of them has got few interfaces I would like to get metrics for.

Graphs are showing all the info I would like to get from DB like max, min and avg values for In and Out octets.

Where in DB I can find historical data for device XXX, interface YYY, date ZZZ.

So far I was able to run something like below, but that doesn’t give me any option to select historical data.

I must say that I was browsing through whole DB table by table and I couldn’t find anything related to previous dates.

 

My query:

 

select dev.sysName,

dev.device_id,

prt.port_id,

prt.ifSpeed,

prt.ifInOctets,

prt.ifInOctets_rate,

prt.ifInOctets_perc,

prt.ifOutOctets,

prt.ifOutOctets_rate,

prt.ifOutOctets_perc

from observium.devices as dev

            inner join observium.ports as prt on dev.device_id = prt.device_id

where dev.sysName = ‘XXX’

  and prt.port_label = 'Eth2'

 

 

Any help hips, guides are more than appreciated.

 

Regards,

Piotr Kania
CREDIT SUISSE (POLAND) SP. Z O.O.
Credit Suisse CoE OPS Wroclaw | Monitoring & Instrumentation Solutions, MBHJ 711
Atrium 2 | Warsaw 00-849 | EMEA
Phone +48 22 359 8668
piotr.kania@credit-suisse.com | www.credit-suisse.com