Problem solved :
I used the continuous queries to extract a spread of a value. Then i can
create a top 10.
CREATE CONTINUOUS QUERY spread_ifInDiscards on QLAB RESAMPLE EVERY 5m BEGIN
SELECT spread("ifInDiscards") INTO spread_ifInDiscards from interface group
by description, hostname, time(31d) END
CREATE CONTINUOUS QUERY spread_ifOutDiscards on QLAB RESAMPLE EVERY 5m
BEGIN SELECT spread("ifOutDiscards") INTO spread_ifOutDiscards from
interface group by description, hostname, time(31d) END
CREATE CONTINUOUS QUERY spread_ifInErrors on QLAB RESAMPLE EVERY 5m BEGIN
SELECT spread("ifInErrors") INTO spread_ifInErrors from interface group by
description, hostname, time(31d) END
CREATE CONTINUOUS QUERY spread_ifOutErrors on QLAB RESAMPLE EVERY 5m BEGIN
SELECT spread("ifOutErrors") INTO spread_ifOutErrors from interface group
by description, hostname, time(31d) END
Le mercredi 11 janvier 2017 14:51:58 UTC+1, Benjamin Dénécé a écrit :
>
> 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.
>
>
--
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/8f82ffe8-9a81-441b-b715-96f5a53ce933%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
