I have a Grafana dashboard panel for data with numeric and string values.
but If I execute the below query, I get each column of the DB as a separate data point. and on Alert dashboard I get error that query contains numeric and string types
from(bucket: “VM_Error_Monitoring_Alert”)
This is unfortunately not possible. There is an open feature request.
opened 07:14PM - 28 Feb 17 UTC
type/feature-request
area/alerting/notifications
- Grafana version 4.1.1
- InfluxDB
- Ubuntu 14
- What I did is I tried to s… et up sensible alerts on many servers. I wanted to have a single query report failures on many servers. Query would return a value based on which notification is sent (say count of errors) + tag information that would allow me to identify the error type and specific server failing.
- What I expected it that it'll be absolutely awesome as all the rest of grafana. However alerts don't work with templates (I know there is another issue on that), so I had to put all errors into a single query. Now the problem is that with many servers there is no way to have meaningful notification sent. Meaningful notification would include information on the errors, such as tags, or error message, ect. That would allow to direct it to a right support group.
- What happens instead, is that I have to set up individual alert panel for each new server, otherwise I can't send meaningful notifications. That of course allows to switch notifications on and off easily with a high fidelity, but requires a lot of panel duplication that is tedious and could have been avoided.
I think this is a relatively small and useful request to allow notification message to include
- alert condition (say we are alerting on count(*) - include threshold end count(*))
- same as alias by allows, such as $tag_system or $tag_error_type, etc
