SELECT <some_field>, container_image FROM docker_container_net GROUP BY host
You must have a field in the SELECT clause, but otherwise that will return the results. It will have massive duplication, though, since it will return the container_image for every point. Otherwise there's no great way to do it. Tags are metadata, not primary data, and the tools for querying them are limited. On Mon, Jun 13, 2016 at 6:22 PM, Quick Query <[email protected]> wrote: > Hi There, > > I want to be able to list all images on a given host. > So, I am trying the following query: > SHOW TAG VALUES FROM "docker_container_net" WITH KEY IN > ("container_image", "host") > > I would like to get this list per "Host". Anyway I can do this? > > Appreciate any help/pointers. > > Cheers! > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" 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/b32416e3-2d3d-47cf-8eb2-6dcf54aae034%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/b32416e3-2d3d-47cf-8eb2-6dcf54aae034%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/CALGqCvOW-nMidjrvHSEbaZAbeSsWKcq2E1PTtpQoBmaXe4XOLQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
