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?