Create Report To Show Devices Missing A Windows Update
What is the best way to create a report to list devices that do not have a Windows Update installed?
The update is KB4486153.
I have tried the following but get 0 results.
SELECT MACHINE_ID as TOPIC_ID,
KBSYS.PATCH.TITLE AS PATCH,
MACHINE.NAME AS MACHINE,
JOIN KBSYS.PATCH ON (KBSYS.PATCH.ID = PATCH_MACHINE_STATUS.PATCH_ID)
JOIN MACHINE ON (MACHINE.ID = PATCH_MACHINE_STATUS.MACHINE_ID)
KBSYS.PATCH.PATCH_IDENTIFIER IN ('KB4486153')
PATCH_MACHINE_STATUS.PATCH_INSTALLED = 0
KBSYS.PATCH.IS_SUPERCEDED = 0
PATCH_MACHINE_STATUS.PATCH_APPLICABLE = 1
GROUP BY MACHINE.ID
Be the first to answer this question