/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


K1000 report on patches no longer detected

02/25/2016 893 views

We use both WSUS and the K1000 in our environment. A recent Office 2013 patch (KB3114717) was causing problems in our installed base, so I have been testing removal via WSUS ("Approve for removal"). It's working great (I believe), and the K1000 sees it as "no longer detected" on the test machines. All good, right?

 

Well... is there any way in the K1000 to report on a removed a/k/a "no longer detected" piece of software/patch? Or do I search on its absence? Love to hear the input.

 

Thanks!
Michelle

1 Comment   [ + ] Show comment

Comments

  • In Control Panel > History > Subscriptions > Assets do you have "Software" checked under "Computer"? On that same page, what's the value of "Retain Asset History:" ?

All Answers

0
I would recommend searching for its absence. This is fairly easy to do:
SELECT PMS.STATUS_DT, M.NAME, PMS.STATUS, P.TITLE 
FROM KBSYS.PATCHLINK_PATCH P
LEFT JOIN ORG1.PATCHLINK_MACHINE_STATUS PMS on P.UID = PMS.PATCHUID
LEFT JOIN MACHINE M on M.ID = PMS.MACHINE_ID
WHERE P.IDENTIFIER = "KB3114717"
That will show you the status for every machine for that particular patch.

Answered 02/26/2016 by: chucksteel
Red Belt

 
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