Is there a way to use the K1000 patch management feature to detect KB3035583?
I'm a bit new to the K1000 and am starting to learn about its patch management feature. Something I'd like to do is detect all workstations that have the infamous KB3035583 (Win 10 upgrade) patch. I can create a schedule that will detect all patches but I can't seem to find a way to detect this specific KB. Am I missing something obvious or am I trying to "use a wrench to drive a nail?"
Any advice would be greatly appreciated.
Thanks!
Bryan
Any advice would be greatly appreciated.
Thanks!
Bryan
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
rockhead44
8 years ago
Top Answer
Do you just need to know which machines have the patch? If so, this will create a report to show all machines that have the patch applied.
Under Inventory-->Software you should find the patch listed as:
"Update for Microsoft Windows (KB3035583)"
Go to Reports and "Choose Action" Pick New (SQL) and paste the following code then name and Save your report:
SELECT DISPLAY_NAME, DISPLAY_VERSION, MACHINE.NAME, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED, MACHINE.USER_NAME
FROM MACHINE
LEFT JOIN MACHINE_SOFTWARE_JT ON MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
LEFT JOIN SOFTWARE ON MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
WHERE DISPLAY_NAME = 'Update for Microsoft Windows (KB3035583)'
Now you can generate this report to show which machines have the patch installed.
Comments:
-
Awesome, thanks, rockhead that's exactly what I needed to know! - bryan172 8 years ago
Posted by:
pazouz
8 years ago
You may want to check your patch subscription settings as well - do you have them set to inactivate superseded patches? If so I think that KB 3035583 was replaced by KB 894199 making it into a recommended update, so you can look for that as well.
Comments:
-
That's a good point. I know there are several Windows 10 KB's out there and I want to kill them all. Thanks! - bryan172 8 years ago
