Lot of text in response to alerts.php -d:
DEBUG!
Start: Tue, 13 Jun 2017 11:29:44 -0400
ClearStaleAlerts():
SQL[SELECT alerts
.id
AS alert_id
, devices
.hostname
AS hostname
FROM alerts
LEFT JOIN dev ices
ON alerts
.device_id
=devices
.device_id
RIGHT JOIN alert_rules
ON alerts
.rule_id
=alert_ru les
.id
WHERE alerts
.state
!=0 AND devices
.hostname
IS NULL]
RunFollowUp():
SQL[SELECT alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state != 2 && alerts
.state > 0 && alerts.open = 0]
RunAlerts():
SQL[SELECT alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state != 2 && alerts
.open = 1]
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_l
og.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name FROM alert_log,alert_
rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ‘2’ && alert_log.rule_id = ‘9’ && ale
rt_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘2’]
SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE al
ert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = ‘2’ ) || alert_map.target
= ‘2’ )]
SQL[SELECT alerts.alerted,devices.ignore,devices.disabled FROM alerts,devices WHERE alerts.device_id =
‘2’ && devices.device_id = alerts.device_id && alerts.rule_id = ‘9’]
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_l
og.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name FROM alert_log,alert_
rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ‘3’ && alert_log.rule_id = ‘10’ && al
ert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘3’]
SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE al
ert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = ‘3’ ) || alert_map.target
= ‘3’ )]
SQL[SELECT alerts.alerted,devices.ignore,devices.disabled FROM alerts,devices WHERE alerts.device_id =
‘3’ && devices.device_id = alerts.device_id && alerts.rule_id = ‘10’]
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_l
og.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name FROM alert_log,alert_
rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ‘5’ && alert_log.rule_id = ‘11’ && al
ert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘5’]
SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE al
ert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = ‘5’ ) || alert_map.target
= ‘5’ )]
SQL[SELECT alerts.alerted,devices.ignore,devices.disabled FROM alerts,devices WHERE alerts.device_id =
‘5’ && devices.device_id = alerts.device_id && alerts.rule_id = ‘11’]
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_l
og.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name FROM alert_log,alert_
rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ‘1’ && alert_log.rule_id = ‘11’ && al
ert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘1’]
SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE al
ert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = ‘1’ ) || alert_map.target
= ‘1’ )]
SQL[SELECT alerts.alerted,devices.ignore,devices.disabled FROM alerts,devices WHERE alerts.device_id =
‘1’ && devices.device_id = alerts.device_id && alerts.rule_id = ‘11’]
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_l
og.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name FROM alert_log,alert_
rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ‘4’ && alert_log.rule_id = ‘11’ && al
ert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘4’]
SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE al
ert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = ‘4’ ) || alert_map.target
= ‘4’ )]
SQL[SELECT alerts.alerted,devices.ignore,devices.disabled FROM alerts,devices WHERE alerts.device_id =
‘4’ && devices.device_id = alerts.device_id && alerts.rule_id = ‘11’]
RunAcks():
SQL[SELECT alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state = 2 && alerts.
open = 1]
End : Tue, 13 Jun 2017 11:29:44 -0400