Currently I have a query :
SELECT mean("value") FROM /^abc\.concourse\.(worker*|web*).*\.system_mem_percent$/ WHERE $timeFilter GROUP BY time($__interval), * fill(null)
This works perfectly. Only measurements with web and worker get listed.
However, I am trying to figure out the inverse of this query. I.E select mean value from those measurements that DO NOT have worker or web in its name. How do I do the create a regex that excludes measurements that have ‘web*’ and ‘worker*’ in its name.