Support Forum

Posted: **Tue May 31, 2016 2:59 pm**

Hello! I'd like to get some insight in how Patch Remedy determines an agent needs a reboot. Ideally, I'd like to create a group that would contain all agents reported as needing a reboot and create some automation around rebooting those machines at specific times. I don't see anything in the 3 tables I have for Patch Remedy so it must be pulling this information elsewhere.

As an alternative, it would be nice if agents were auto-joined to groups like this so they can be managed outside of Patch Remedy for some of these tasks.

Posted: **Wed Jun 01, 2016 7:22 pm**

here ya go, Here is how you can grab reboot needed from "computers" flags column

Code: Select all

SELECT c.ComputerID AS ID, IF(c.LastContact > DATE_ADD(NOW(),INTERVAL -5 MINUTE),'Yes','No') AS `Online`,if((c.flags & 1024 = 1024), 'Yes','No') AS reboot, c.`Name` AS NAME, m.`Name` AS CLIENT From computers c LEFT JOIN clients m ON c.ClientID = m.ClientID

Posted: **Wed Jun 08, 2016 9:34 pm**

Thank you Cubert. Greatly appreciated!

Support Forum

Creating Searches from Patch Remedy Data

Creating Searches from Patch Remedy Data

Re: Creating Searches from Patch Remedy Data

Re: Creating Searches from Patch Remedy Data