Filtering InfluxDB series by parts of thier name

[sontags]

I am feeding nmon data from multiple servers into an InfluxDB and use Grafana for basic analytics/monitoring. The series feed into InfluxDB are named in simple patterns where elements are separated by a dot, for example:

[prefix].[servername].[nmon-section].[metric]

For example raw.raspi.CPU_ALL.SysPercent contains system cpu usage over all CPU's on the node raspi.

Now, for example, I would like to have a filter at the place of the [servername]. The query would look somehow like that:

from /raw.*'[[servername]]'*.CPU_ALL.*/ where  time > 1406045460s and time < 1406047512s group by time(1s)  order asc

A input box (in this case better than a dropdown) would allow me to filter.

Currently I do this via scripted dashboards which works fine, but thats somehow lacking of flexibility...

Cheers Daniel

[tmonk42]

+1

This was one of my favorite features when I was using graphite/cyanite as the backend.

[torkelo]

An overhaul of the filter feature (with big InfluxDB improvements) is planed for v1.8

[dzrw]

👍

[pauldix]

The list series query now has support for matching on regexes influxdata/influxdb#376. It's in master now and will be in the 0.8 release. We'll push an RC by tomorrow afternoon with this for testing.

That should make this kind of filtering fast when you're building the query and you want to do quick lookups to see which series will match

[torkelo]

@pauldix that is great. Will start working on the filter feature overhaul next week I hope.

[sevastos]

👍

[torkelo]

Progress on InfluxDB and filter/templating support!

Only need to solve how to handle an "All" option that is when a templated variable has an "all" option that should show all series. The metric queries will need all need to be using a regex syntax and the "all" value would need to be a regex pattern.

[torkelo]

Ready to test in master! There are some breaking changes for InfluxDB users in master (read changelog for more details)

[sevastos]

Looking good! However, I'm temporarily stuck on Influx 0.7 and list series /regex/ seems like a 0.8 feature, so can't test atm 😦

[sevastos]

Amazing job @torkelo, works great and the new series specific overrides is really awesome!

[blufor]

that is great work! goodbye, last remnants of graphite :)

[joelittlejohn]

A note for anyone that gets here from Google, since InfluxDB 0.9 you'll need SHOW series instead of list series.