/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Create Report To Show Devices Missing A Windows Update

03/11/2020 241 views

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

1 Comment   [ + ] Show comment

Comments

  • 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.

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