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.commailto:piotr.kania@credit-suisse.com | www.credit-suisse.comhttp://www.credit-suisse.com =============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ===============================================================================