Hello, is it possible to get a SQL report that shows the above?
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:
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 SCHEDULECOUNTFROM MACHINELEFT JOIN PATCHLINK_SCHEDULE_MACHINE_STATUS on MACHINE_ID = MACHINE.IDGROUP BY MACHINE.IDHAVING 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.
Sign up today to participate,
stay informed, earn points and establish a reputation for yourself!