[Solved] Alarms on TimeSeries Graph MySQL datasource

[lucatonello]

Hello all,
I would like to implement an Alert rule for each ITEM of a mysql colum table.
For Example I have this Table:
Alias TestDateTime metric
A TIME1 3
A TIME2 2.8
A TIME3 5
B TIME4 4.2
B TIME5 7

I would like to create an alert rule for each Alias where metric is below 4.
This, avoiding to create a query for each Alias. I know that variable is not yet implemented, any advice?

Thanks and Regards,

[torkel]

you can issue a query that returns many series.

http://docs.grafana.org/alerting/rules/#multiple-series

[lucatonello]

Hello Torkel, thanks for your response. How can I configure many series in a single query?
Thanks,

[mefraimsson]

Just use a regular timeseries query selecting alias as metric, something like this:

SELECT 
  $__time(TIME), 
  alias as metric, 
  metric as value 
FROM <table name> 
WHERE $__timeFilter(TIME) 
GROUP BY TIME, alias 
ORDER BY TIME

Marcus

[lucatonello]

Thanks All! I’ll try to set an alarm rules with this settings.