select
$__timeFilter(receive_datetime) as time_sec,
count(*) as value,
service as metric
FROM processed_agw_alert_queue as GB
WHERE $__timeFilter(receive_datetime) and service=‘OBA’ and severity!=‘0’
What my query good?
alvianno
1
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How can I get alert, if my metrics(my_metrics) has consumed 0 messages from last 24 hours | 0 | 69 | May 31, 2024 | |
| Count over time returns no data for alert | 1 | 1155 | September 22, 2023 | |
| Unable to get expected results for increase(my_metrics[24h]) | 0 | 66 | May 31, 2024 | |
| Query parameter metrics in grafana | 0 | 288 | February 23, 2023 | |
| Count metrics resulting from grafana managed alert and multi series mysql query | 0 | 583 | November 1, 2022 |