I noticed a boatload of alert rule errors about “storage.storage_deleted”. I can’t edit them in the UI. I saw another thread where it was mentioned that they could be edited in the SQL database. I know SQL enough to edit the SQL query. I don’t know Libre enough to edit the builder section.
MariaDB [librenms]> select * from alert_rules where query like '%storage.storage_deleted%';
+----+------+----------+-----------------------------------------------------------------------------------------------------------------------+----------+---------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+------------+-------+
| id | rule | severity | extra | disabled | name | query | builder | proc | invert_map | notes |
+----+------+----------+-----------------------------------------------------------------------------------------------------------------------+----------+---------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+------------+-------+
| 13 | | warning | {"mute":false,"count":"1","delay":60,"invert":false,"interval":300,"recovery":true,"options":{"override_query":null}} | 0 | Space on / is >= 90% and < 95% in use | SELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_deleted = "0 AND storage.storage_descr = "/" AND storage.storage_perc >= 90 AND storage.storage_perc < 95" | {"condition":"AND","rules":[{"id":"storage.storage_deleted","field":"storage.storage_deleted","type":"string","input":"text","operator":"equal","value":"0 AND storage.storage_descr = \"/\" AND storage.storage_perc >= 90 AND storage.storage_perc < 95"}],"valid":true} | | 0 | NULL |
| 14 | | critical | {"mute":false,"count":"1","delay":60,"invert":false,"interval":300,"recovery":true,"options":{"override_query":null}} | 0 | Space on / is >= 95% in use | SELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_deleted = "0 AND storage.storage_descr = "/" AND storage.storage_perc >= 95" | {"condition":"AND","rules":[{"id":"storage.storage_deleted","field":"storage.storage_deleted","type":"string","input":"text","operator":"equal","value":"0 AND storage.storage_descr = \"/\" AND storage.storage_perc >= 95"}],"valid":true} | | 0 | NULL |
+----+------+----------+-----------------------------------------------------------------------------------------------------------------------+----------+---------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+------------+-------+
2 rows in set (0.000 sec)