Search the Community
Showing results for tags 'internal'.
Found 1 result
All-- So I have an issue at times where the LT-Offline Server does not work correctly. Specifically the server is reporting back to the database, but overall the machine is hosed. When I look at Automate, the agent is not checked in/show as offline. When I connect to another node that is online I can ping the host, but cannot connect to it. Essentially requiring the server to be rebooted to come back up and come online. The issue here is that the offline monitor should kick off. But because it is still sending some heartbeat info to the SQL, it is essentially telling Automate that it is still on. I now have a group for server that I want to apply a new internal monitor for, but the logic is hard to come by. Would anyone be able to help me out? I have tried the below and it is not working SQL command SELECT * FROM computers WHERE lastContact <= NOW() -INTERVAL 10 MINUTE I also tried this one SELECT NAME, Lastcontact FROM computers WHERE DATE(LASTCONTACT)>NOW() -INTERVAL 10 MINUTE withing SQLyog, the second item returns 0 results. Then I would also need to understand the logic required to actually setup the monitor if someone has the time. Thanks Jason