grafana查询夜莺数据库中当前告警信息

SELECT
  rule_name as name,
  COUNT(*) + (ROW_NUMBER() OVER (ORDER BY rule_name) * 0.00000001) as value -- 添加偏移量，避免值相同时饼图颜色一致。
FROM alert_cur_event WHERE severity <= 2 -- 1：紧急，2：警告，3：信息。根据需要显示不同级别告警调整where条件。
GROUP BY name

-- 显示名称增加符号
SELECT
  CONCAT('【', group_name, '】') as group_name_with_symbol,
  CONCAT('★ ', rule_name) as rule_name_with_symbol,
  COUNT(*) + (ROW_NUMBER() OVER (ORDER BY group_name,rule_name) * 0.00000001) as value
FROM alert_cur_event 
WHERE severity <= 2
GROUP BY group_name,rule_name