On Wednesday, January 11, 2017 at 6:51:58 AM UTC-7, Benjamin Dénécé wrote: > Hello everyone, > > I'm stuck with a problem. To perform a network audit, i need to make a top n > of interfaces by packets dropped. > > I've tried this request : > > select (spread(ifInDiscards) from interface group by description > > But it display a lot of "0" (it's ok because some interfaces don't dropped > packets). > > So i tried to order by desc but it don't work. > Also try a "limit 10" but it don't work too. > > And a top(spread(ifInDiscards),10) but it tell me this : ERR: error parsing > query: only fields or tags are allowed in top(), found spread(ifInDiscards) > > I have some interface who are dropping but they are not sorted anymore. > > So my question is : it is possible to perform this with any method or i need > to open a ticket to the influx github? > > Sincerly, > > Benjamin DENECE > > PS : use InfluxDB with telegraf snmp inputs and Grafana.
I'm trying something similar with Derivative. I'll give the continuous query a try but is there a way to do this with just a single query? -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/8855066c-a7e0-46b3-b742-e247b99a7090%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
