Showing Measurements, but excluding specific results

influxdb
#1

Hello,

I am trying to return all measurements with a specific tag value, but exclude a few measurements that have specific words in their name.

As an example I have these three measurements:

  • System A - Dog
  • System B - Dog
  • System A - Dog and Cat

I want to return all measurements, but exclude any with the name Cat in them.

Right now, my query looks like this:
SHOW MEASUREMENTS WHERE device_type = "xyz’

This returns all of the measurements, but is including that third one I don’t want. How do I exclude it?

#2

@Adam_Cavaliere I’m pretty sure this requires single quotes. Does this query work for you?

SHOW MEASUREMENTS WHERE "device_type" = 'xyz'