So Grafana 10 is out and I still need the same solution. I STILL need a column(string) in MySQL to be a label so I can do dynamic alerting. I’m giving this one last try (crossing my fingers) that there is an actual solution. I should be able to do the following: SELECT Date, Disk_Usage1 AS “/” FROM…

@jasonmallory try change format from Table to Timeseries. [image] Also, use query builder and assign correct aliases for columns. If / is value column then your SQL will look like SELECT Date as time, Host, '/' as value FROM ...

MySQL Columns As Labels For Alerting

Grafana Alerting

georgerobinson July 11, 2023, 4:55pm 14

At this point should I be able to do the following?

You need to use $labels as per the example here.

2 Likes

Topic		Replies	Views
Dynamic Labels For Alerting Alerting	11	4066	April 28, 2023
Figuring Out Labels and Values For Alerting Alerting	2	252	October 27, 2023
Using labels or tags with grafana alerting Alerting	0	1275	June 20, 2022
I Would like to add alert on mysql table Alerting mysql , alerting	1	504	July 27, 2022
Add custom info (strings) from mysql query's result to alerts annotations Alerting query-help , alert-templating	0	562	December 9, 2022

MySQL Columns As Labels For Alerting

Related topics