Really Stalled Agents?

[SamOrlando]

So I have been using the Stalled Agents plugin for several months and added a morning routine to check it and process restarts through ScreenConnect. All is working great.

But then in a recent review of Agents that have been offline for 120+ days, we discovered devices that were reporting into their networks AD environment and Webroot, but not Automate, which means the agent is not reporting in and the device is live.

How come these do not show up in the Stalled Agents Plugin? Wouldn't commands/scripts be piling up for those agents?

[Cubert]

We run the following to find offline agents

Code: Select all

SELECT c.computerid, c.name as ComputerName, a.name as ClientName, IF(c.LastContact > date_add(now(),interval -24 hour),'Yes','No') As SeenResently, c.LastContact from computers c LEFT JOIN clients a ON a.clientid = c.clientid WHERE c.LastContact < date_add(now(),interval -5 minute) ORDER BY a.Name;

It looks for agents not checked in for 24 hours or more.

If you execute this in SQL do you get those agents showing up?