/build/static/layout/Breadcrumb_cap_w.png
04/29/2019 237 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.