Hi folks,
I have just installed influxdb and parallel to mysql & rrd’s i can see the data into the influx now.
I have also installed grafana for graphing. successfully connected to influx instance. Now i have to show the graphs for our port usage similar to what we are having in the librenms.
Can someone guide me the query for that please?
Thank you.
Have you searched through other threads first?
For sure but i could not find the query for the port. and i am bit new to timestamp db as well.
I really appreciate your help.
Thank you
Furthermore i just run a test query in the influxdb
SELECT * FROM ports order by time desc limit 1;
I have found the results , everything seems fine i just need to know the query to show the port usage graph per host for example.
Have you tried importing the Grafana LibreNMS Interfaces dashboard?
https://grafana.com/dashboards/2556
It is a pretty good starting point. It has multiple ports queries including math functions and some templating variables.