/build/static/layout/Breadcrumb_cap_w.png

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,
IP
FROM PATCH_MACHINE_STATUS
JOIN KBSYS.PATCH ON (KBSYS.PATCH.ID = PATCH_MACHINE_STATUS.PATCH_ID)
JOIN MACHINE ON (MACHINE.ID = PATCH_MACHINE_STATUS.MACHINE_ID)
WHERE
KBSYS.PATCH.PATCH_IDENTIFIER IN ('KB4486153')
AND
PATCH_MACHINE_STATUS.PATCH_INSTALLED = 0
AND
KBSYS.PATCH.IS_SUPERCEDED = 0
AND
PATCH_MACHINE_STATUS.PATCH_APPLICABLE = 1
GROUP BY MACHINE.ID

Asked 4 years ago 410 views
1 Comment   [ + ] Show comment
  • So you mean you want to know what machines are missing a patch as opposed to do not have it installed? The two scenarios are different, missing meaning it should have it and it is installed as opposed to not installed as it is not required?

    The patches will be marked in a different way and may help with regards to understanding what we are looking for in the database. - Hobbsy 4 years ago

Answers (0)

Be the first to answer this question

 
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