K1000 report on patches no longer detected
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
-
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:" ? - JasonEgg 8 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
8 years ago
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.
