/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


machines added to Kace that are Not part of a patch Schedule

04/29/2019 396 views

Hello, is it possible to get a SQL report that shows the above?


Thanks


0 Comments   [ + ] Show comments

Comments


All Answers

1

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.

Answered 04/29/2019 by: chucksteel
Red Belt

  • 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.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ