Hi,
i created a sql query which is working fine in mysql. When i put the same query in an alert rule, the rule seems not to be working. Can anybody help me to find out what is going wrong here? Below is the sql query that i build an is working in mysql:
SELECT * FROM eventlog WHERE (datetime >= DATE_ADD(NOW(), INTERVAL -300 SECOND) ) AND ( eventlog.message LIKE “%HTTP Status code%” ) AND ( eventlog.message NOT LIKE “%200%” )
i added some extra columns:
SELECT * FROM devices,eventlog WHERE (devices.device_id = ? AND devices.device_id = eventlog.device_id) AND (eventlog.datetime >= DATE_ADD(NOW(), INTERVAL -300 SECOND) ) AND eventlog.message LIKE “%HTTP Status code%” AND eventlog.message NOT LIKE “%200%”