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.
For more options, visit https://groups.google.com/d/optout.
