Triggering Alert Based on Table Query

Grafana Alerting
,
1

  • What Grafana version and what operating system are you using?
    Grafana V7.2 and Windows

  • What are you trying to achieve?
    Requirement is to Trigger the alert if two conditions satisfies.
    Condition 1: If it reaches threshold, check the condition 2
    Condition 2: Check the table whether any records exists between the timeframe.if yes, send the email

  • How are you trying to achieve it?
    Tried to define Query A and Query B. Query A is the graph and On Query B creates the Oracle Query to read the data from the table.

ex., select column1 from table 1 where $_timefrom >= dateFrom and $_timeto < dateTo

  • What happened?
  1. Template variable is not supported error coming up
  • What did you expect to happen?
    Two condition to be satisfied to send alert
2

Welcome to the :grafana: Forum!

Assuming you are using InfluxDB, are you using 1.8 or 2.0? I think you might need to move to 2.0 and use the Flux language to accomplish what you have described. The question may better be answered on the InfluxDB forum.