Influxdb help

I’m trying to set this up to monitor bandwidth for our wisp. Firstly I have it transferring data supposedly, I can go tinot grafana and show data in a single stat panel, but not in a graph for some reason. Anyways, what metric do i need to use in order to monitor bandwidth. I know the data is in librenms, but how do I find it or make sure it gets sent to influxdb.

Bandwidth info should be there in IFINOCTETS and IFOUTOCTETS, you have to do a calculation to display it in a graph. I don’t use influxdb anymore to share my graphs but others might (it’s worth asking in irc as I know others use it)

Check out this blog (Skip past all the setting it up stuff) https://lkhill.com/using-influxdb-grafana-to-display-network-statistics.

An example query for me is:

SELECT derivative(mean(“INOCTETS”), 1s) FROM “ports” WHERE “hostname” = ‘HOST’ AND “ifName” = ‘PORT’ AND $timeFilter GROUP BY time($interval) fill(null).

You can do awesome stuff with templates etc to make it more general.

Thanks for the responses. I’ve seen the ifinoctets and was attempting to use that and the derivative method seems to give me gbits per second and a really off number. We are currently using PRTG to monitor stuff and they seem to be accurate but just not as pretty as grafana can be. But anyways the numbers I get with PRTG vary rather drastically that what my calc displays in grafana using the ifinoctets_rate.

Don’t use rate. You need to use INOCTETS like the example above.

Ya I had just recognized that. I tried using that but my graph is very rounded and doesn’t have spikes. Is there a way I can show live throughput? And thank you for your help, it is very much appreciated.

You can’t get live data as we don’t support that no.