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] > <javascript:>> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/8d85a411-c06a-436c-a161-05cc18fbd319%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
