TRIGGER NOTIFICATION that FAILS:
Start: Mon, 09 Apr 2018 03:26:02 +0000
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 FROM alerts WHERE alerts.state != 2 && alerts.state > 0 && alerts.open = 0]
RunAlerts():
SQL[SELECT alerts.id, 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_log.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 = '14' && 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='1' OR dg.device_id='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 = '14']
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1']
SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '1' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1]
SQL[UPDATE `alert_log` set `details` ='xڅT▒n▒0▒g[▒V▒:5▒▒4@▒▒hoE!▒-▒▒H▒▒▒A▒▒3Zl9hуeq▒▒▒G▒▒▒ʳ▒;▒▒ƬV▒Z▒▒V▒▒▒[▒dP▒▒▒\Z▒▒mFl+9▒▒▒D▒
                                                                                                                              Q▒7$3▒▒▒+▒p<▒▒ ̖▒r▒▒▒C▒▒▒▒L▒f▒҄f▒▒䪕r▒4M▒▒?▒+▒▒▒▒▒\0▒▒{▒\\▒84▒▒gÜ▒▒▒▒▒)▒=\Z▒▒▒▒2▒8՘▒P▒▒P▒h▒q▒
▒▒)7X▒ʠE4\\▒~▒▒▒[▒▒4YQ  ǶH▒▒▒ͽ.▒▒v▒8y▒▒⥿[▒▒8▒▒▒/▒▒▒)▒Y▒▒▒5w%▒wm▒[▒▒UF׽▒c▒▒X▒p▒▒QR▒▒4▒V▒▒b37▒▒
                                                                                             ▒,6▒▒▒▒̷;\'▒V▒*L▒▒%▒▒▒▒5=#\Z!;▒]Cm▒▒!▒\r▒▒▒r▒ ▒▒Vڎ▒\\Tñ5▒▒]-▒%▒\\s勓Q▒9_-▒▒9M▒tuE▒<▒rz▒)▒▒1▒=\r▒▒▒z▒coi
Ԏ▒▒X▒▒▒w▒▒▒
           ▒]▒▒<NOU>▒mH}\n▒]▒?▒▒▒e▒I▒u▒jdo▒/ ▒▒:▒b(▒▒▒\\\rk▒-^cy)▒e▒▒▒p[▒R▒Y▒▒▒\'(▒▒▒▒Q%I▒E▒Qk▒f▒▒~,▒' WHERE id = '1082']
SQL[SELECT count(*) from `device_relationships` WHERE `child_device_id` = '1']
SQL[SELECT attrib_value FROM devices_attribs WHERE attrib_type = "disable_notify" && device_id = '1']
SQL[]
SQL[SELECT hostname, sysName, sysDescr, hardware, version, location, purpose, notes, uptime FROM devices WHERE device_id = '1']
SQL[SELECT `template`,`title`,`title_rec` FROM `alert_templates` JOIN `alert_template_map` ON `alert_template_map`.`alert_templates_id`=`alert_templates`.`id` WHERE `alert_template_map`.`alert_rule_id`='14']
SQL[SELECT `template`,`title`,`title_rec` FROM `alert_templates`  WHERE `name`='Default Alert Template']
Issuing Alert-UID #1082/1: ; ; mail => ERROR: You must provide at least one recipient email address.
SQL[SELECT `devices`.*, `lat`, `lng` FROM `devices` LEFT JOIN locations ON `devices`.`location`=`locations`.`location` WHERE `device_id` = '1']
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '1']
SQL[SELECT * FROM `vrf_lite_cisco` WHERE `device_id` = '1']
SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES ('1','1','NULL','error',NOW(),'5','Could not issue warning alert for rule \'Processor usage over 50%\' to transport \'mail\' Error: You must provide at least one recipient email address.','')]
; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
SQL[UPDATE `alerts` set `alerted` ='1' WHERE rule_id = '14' && device_id = '1']
SQL[UPDATE `alerts` set `open` ='0' WHERE rule_id = '14' && device_id = '1']
RunAcks():
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state = 2 && alerts.open = 1]
End  : Mon, 09 Apr 2018 03:26:02 +0000
DEBUG!
Start: Mon, 09 Apr 2018 03:27:01 +0000
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 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 FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = '1' && alert_log.rule_id = '14' && 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='1' OR dg.device_id='1')]
SQL[]
RunAlerts():
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state != 2 && alerts.open = 1]
RunAcks():
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state = 2 && alerts.open = 1]


RECOVERY NOTIFICATION:
Start: Mon, 09 Apr 2018 03:36:01 +0000
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 FROM alerts WHERE alerts.state != 2 && alerts.state > 0 && alerts.open = 0]
RunAlerts():
SQL[SELECT alerts.id, 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_log.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 = '14' && 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='1' OR dg.device_id='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 = '14']
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1']
SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '1' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1]
SQL[UPDATE `alert_log` set `details` ='xګV▒▒+I-*K▒Q▒2452621▒43▒\0[|▒' WHERE id = '1083']
SQL[SELECT count(*) from `device_relationships` WHERE `child_device_id` = '1']
SQL[SELECT attrib_value FROM devices_attribs WHERE attrib_type = "disable_notify" && device_id = '1']
SQL[]
SQL[SELECT hostname, sysName, sysDescr, hardware, version, location, purpose, notes, uptime FROM devices WHERE device_id = '1']
SQL[SELECT `template`,`title`,`title_rec` FROM `alert_templates` JOIN `alert_template_map` ON `alert_template_map`.`alert_templates_id`=`alert_templates`.`id` WHERE `alert_template_map`.`alert_rule_id`='14']
SQL[SELECT `template`,`title`,`title_rec` FROM `alert_templates`  WHERE `name`='Default Alert Template']
SQL[SELECT alert_log.id,alert_log.time_logged,alert_log.details FROM alert_log WHERE alert_log.state != 2 && alert_log.state != 0 && alert_log.rule_id = '14' && alert_log.device_id = '1' && alert_log.id < '1083' ORDER BY id DESC LIMIT 1]
SQL[UPDATE `alert_log` set `details` ='x▒\0\0\0\0' WHERE id = '1083']
Issuing Alert-UID #1083/0: ; ; mail => OKSQL[SELECT `devices`.*, `lat`, `lng` FROM `devices` LEFT JOIN locations ON `devices`.`location`=`locations`.`location` WHERE `device_id` = '1']
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '1']
SQL[SELECT * FROM `vrf_lite_cisco` WHERE `device_id` = '1']
SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES ('1','1','NULL','alert',NOW(),'1','Issued recovery for rule \'Processor usage over 50%\' to transport \'mail\'','')]
; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
SQL[UPDATE `alerts` set `alerted` ='0' WHERE rule_id = '14' && device_id = '1']
SQL[UPDATE `alerts` set `open` ='0' WHERE rule_id = '14' && device_id = '1']
RunAcks():
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state = 2 && alerts.open = 1]
End  : Mon, 09 Apr 2018 03:36:02 +0000
DEBUG!