I am running checks on icinga2 with a influxDB which is connected with grafana. I have a server system which is have mostly the same name pattern with different “serviceGroups” for DEV Testing and PROD.
How can I create a Query in Grafana -> InfluxDB using the serviceGroups. I tested different types of it
servicegroups = …
… but nothing is working.
q:“SELECT sum(“value”) FROM “check-access-log” WHERE (“hostname” =~ /servernamemw(a|b)/ AND “serviceGroups” = ‘prod’) AND time >= now() - 6h GROUP BY time(1m) fill(null)”