Create alerts with values from tables

Grafana Alerting
1

I created this table with this query

image
image2061×1006 123 KB

i am trying to create alert where if temperature of CPU1 Temp goes higher than 60 to run an alert and when it goes below 60 to resolve it.

Could someone help?

2

@zzozz there are two approaches to this . I will tell the easiest one applicable here.

  1. In the alert rule - separate out the queries for CPU1 Temp, CPU_VRMN Temp,…so on. Right now everything is in query A. You can separate them in multiple queries B,C,D,E…
    And put alert on any of the query.

    or use the query

(sensorReading{instance="$instance", sensorIDString="CPU1 Temp"} )

  1. Add expression and select “Threshold” from dropdown. Then place the query denotion in the input section ( This is the query , on whose outcome threshold will be put)
    image
    image650×361 14.7 KB
    .
    Based on your usecase you can have
    Toggle on the custom recovery threshold , choose
    IS ABOVE and value for “Stop alerting when below” should be set to 60.

Another way is that to avoid any more expression is to directly use the query
(sensorReading{instance="$instance", sensorIDString="CPU1 Temp"}>60)

And set this as an alert condition
Feel free to reach out if in case you face any issue.