I am trying out combination of newest releases of telegraf, influxdb and grafana.
My goal is monitor thousands of network devices from which every device might have hundreds of interfaces.
I what to create overview dashboard with graphs of for example top 10 most utilized interfaces per device.
I have made graph with all interfaces per device with query:
SELECT derivative(“ifHCInOctets”, 1s) *8 FROM “interface” WHERE (“agent_host” = ‘test-router.test.net’) AND $timeFilter GROUP BY “ifDescr”
I have tried SLIMIT but it randomly selects some interfaces. I can not find a way to limit output to TOP 10 series.
For example Graphite has function highestAverage (10).
I saw this question asked in forums few times over the years but no solid answer was provided.
Perhaps this is possible to do with a help of other influx products.