Interval: 6 Hours
Send Fail After Success
Table to check: computers
Field to Check: LastContact
Check Condition: GreaterThan
Result: DATE_ADD(NOW(), INTERVAL -6 MONTH)
Identity Field: computers.name
Additional Condition: computers.computerid in(select computerid from computerconfig where computerconfig.heartbeatenable=1) AND computers.computerid in(Select computerid from computers where computers.lastcontact < (date_add(now(),interval -3 MONTH)))