Are HOST_NAME1, HOST_NAME2, etc tag keys or tag values? They seem more like tag values to me.
Also, please use the CLI for querying and copy/paste of results. The admin UI can have browser issues that obscure or drop query results. On Tue, Jun 14, 2016 at 2:00 PM, Quick Query <[email protected]> wrote: > Just noticing that the following query also does not work: > SHOW TAG VALUES FROM "docker_container_net" WITH KEY IN ("HOST_NAME", > "container_image") > > It gives me the same list even if I use like: > SHOW TAG VALUES FROM "docker_container_net" WITH KEY IN ("HOST_NAME1", > "container_image") > OR > SHOW TAG VALUES FROM "docker_container_net" WITH KEY IN ("HOST_NAME2", > "container_image") > > > Cheers! > > > > On Monday, June 13, 2016 at 8:13:15 PM UTC-7, Quick Query wrote: >> >> Hi Sean, >> >> Thanks for the quick reply! >> >> When I tried -> SELECT * from docker_container_net where time >> Response was -> >> *docker_container_net* >> timebuild-datecontainer_idcontainer_imagecontainer_namehostlicensename >> networkrx_bytesrx_droppedrx_errorsrx_packetstx_bytestx_droppedtx_errors >> tx_packetsvendor >> >> When I tried -> >> SELECT container_id from docker_container_net group by host group by host >> Response was -> >> docker_container_nethost:Host-1 >> timecontainer_id >> >> Is there anyway to get the container_id list per host? I mean result set >> should be only for that Host. >> >> >> Cheers! >> >> >> On Monday, June 13, 2016 at 5:51:27 PM UTC-7, Sean Beckett wrote: >>> >>> 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/c403bb53-5d6c-4964-9a77-41df36445caa%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/c403bb53-5d6c-4964-9a77-41df36445caa%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/CALGqCvORbgL41y3k-qJQWKbW9QELY-UfUvSoUQ855xMKFkOWZA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
