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, 6:24am 3

Hi Jason! Have you tried this example here?

Topic		Replies	Views
Dynamic Labels For Alerting Alerting	11	5457	April 28, 2023
Figuring Out Labels and Values For Alerting Alerting	2	293	October 27, 2023
Alerting with MySQL datasource MySQL mysql , alerting	1	1579	July 13, 2022
Bar gauge with MySQL Table Grafana	2	5146	June 26, 2020
Monitor & alerting On/Off state of setting in MS SQL table Grafana alerting	0	94	March 14, 2024

MySQL Columns As Labels For Alerting

Related topics