root@librenms-s:/opt/librenms# ./alerts.php -d
DEBUG!
Start: Sat, 04 Aug 2018 08:22:07 +0300
ClearStaleAlerts():
SQL[SELECT `alerts`.`id` AS `alert_id`, `devices`.`hostname` AS `hostname` FROM `alerts` LEFT JOIN `devices` ON `alerts`.`device_id`=`devices`.`device_id`  RIGHT JOIN `alert_rules` ON `alerts`.`rule_id`=`alert_rules`.`id` WHERE `alerts`.`state`!=0 AND `devices`.`hostname` IS NULL]
RunFollowUp():
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state, alerts.note FROM alerts WHERE alerts.state != 2 && alerts.state > 0 && alerts.open = 0]
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_log.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name,alert_rules.builder FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = '30' && alert_log.rule_id = '15' && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[SELECT DISTINCT a.* FROM alert_rules a  LEFT JOIN alert_device_map d ON a.id=d.rule_id  LEFT JOIN alert_group_map g ON a.id=g.rule_id  LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id  WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id='30' OR dg.device_id='30')]
Searching for target: devices, starting with storage
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]
Searching for target: devices, starting with devices
Searching for target: devices, starting with storage
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]
SQL[SELECT * FROM devices,storage WHERE (devices.device_id = '30' AND devices.device_id = storage.device_id) AND storage.storage_descr = "/mnt/backup2" AND storage.storage_perc >= 90]
RunAlerts():
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state, alerts.note FROM alerts WHERE alerts.state != 2 && alerts.open = 1]
RunAcks():
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state, alerts.note FROM alerts WHERE alerts.state = 2 && alerts.open = 1]
End  : Sat, 04 Aug 2018 08:22:07 +0300