Really Stalled Agents?

Supports the detector plugin and any feature or other requests around the plugin.
Post Reply
SamOrlando
Posts: 23
Joined: Wed May 01, 2019 2:55 pm
4

Really Stalled Agents?

Post by 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?

User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Really Stalled Agents?

Post by 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?

Post Reply

Return to “Stalled Agents Detector Plugin”