Creating Searches from Patch Remedy Data

[jbrantley]

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.

[Cubert]

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  

[jbrantley]

Thank you Cubert. Greatly appreciated!