machines added to Kace that are Not part of a patch Schedule
Hello, is it possible to get a SQL report that shows the above?
Thanks
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
5 years ago
Detecting the absence of something is always difficult, so I prefer to setup a default value (in this case a default patching schedule), instead. You can see more here:
https://www.itninja.com/question/report-to-find-clients-not-within-a-patching-schedule
That being said, in addition to the query posted by JasonEgg on that post, here is what I came up with:
SELECT MACHINE.ID, MACHINE.NAME, COUNT(PATCHLINK_SCHEDULE_ID) as SCHEDULECOUNT
FROM MACHINE
LEFT JOIN PATCHLINK_SCHEDULE_MACHINE_STATUS on MACHINE_ID = MACHINE.ID
GROUP BY MACHINE.ID
HAVING SCHEDULECOUNT = 0
Rather than looking at the patch schedules themselves, this report looks for machines that do not have any entries in the PATCHLINK_SCHEDULE_MACHINE_STATUS table, which means patching has never run on those systems.
Comments:
-
Many Thanks for your reply, The sql query you posted has opened up another question which im looking into.
What i have seen though is that we have quite a few patch schedules so that this query would not give me the results of the machines that was not applied to a certain patch scheduled. - markc0 5 years ago
