leebaxter,
When I first created the monitor it was not working, but I just left it over night and the next day the monitor was working correctly. I'm not sure which function refreshed to get it working but I would imaging if you Refresh Searches, Do Group Refresh and restart the database agent it will probably start working. I was a little impatient when I originally posted.
Hope this helps.
Thanks,
Cory
I am trying to get this monitor configured correctly. We have version Automate v12 and I'm not sure if the Identity Field or the additional conditions need to be any different because of it. When I try to build and view the query it errors out.
Do you happen to know if this works out of the box with v12? It errors out when I leave the IF and AC the default or if I change them to the one suggested by "Jacobsa".
here is what I got:
Table to check: computer
Field to check: LastContact
Check condition: LessThan
Result: date_add(now(),interval -7 minute)
Identity Field: computers.name,(SELECT v_extradatacomputers.`Notify When Online` FROM v_extradatacomputers WHERE v_extradatacomputers.ComputerID=Computers.ComputerID) AS `Notify`
Additional Conditions: Computers.ComputerID IN (SELECT v_extradatacomputers.ComputerID FROM v_extradatacomputers WHERE v_extradatacomputers.`Notify When Online` LIKE '%@%')
Thanks,
Cory