I have an odd issue with Alert Rules. Two of them show issues. One shows Warning and the other shows down, however there are no active alerts when clicking.
The exact error is “Some devices matching Device Down! Due to no ICMP response are currently alerting”
When clicking on this text, it goes to the alert screen, which is blank.
This is the query that is run to determine how to colour the row, run it in MySQL and post the output, replace 3 with your rule id (hover over the icon on the left of the alert rule).
SELECT * FROM alerts WHERE rule_id = 3 ORDER BY stateDESC,id DESC LIMIT 1;