SELECT host, environment, <anyfield> FROM "system" WHERE environment != ''
On Fri, Nov 25, 2016 at 8:39 AM, <[email protected]> wrote: > Hi there, > > I may be going about this in the wrong way, but could do with some help > with a basic query. I have a measurement named "system". On this > measurement, I can run the following query: > > SHOW TAG VALUES FROM "system" WITH KEY = "host" > > This will return data as such: > > (key) (value) > host server1.example.com > host server2.example.com > host server3.example.com > > > Likewise, I can run the query: > > SHOW TAG VALUES FROM "system" WITH KEY = "environment" > > ...which will return: > > (key) (value) > environment development > environment testing > environment production > > > I need a query that can return hosts with an associated environment, as > below: > > server1.example.com development > server2.example.com testing > server3.example.com production > > How can I go about doing this in InfluxDB, given the tags I already have > in the measurement? > > Apologies for what seems like a basic question. > > Many thanks, > Aaron > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" 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/80511a1a-7148-4c9e-8bf6-8dca63941a56%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" 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/CALGqCvNe_S7gbd2JMMQ6NmGB8-gTHAej9WO6zVpioRp-viGYXA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
