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
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

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

Answered 03/24/2016 by: rockhead44
Tenth Degree Black Belt

  • Awesome, thanks, rockhead that's exactly what I needed to know!
Please log in to comment

Answers

0
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.
Answered 03/24/2016 by: pazouz
Orange Senior Belt

  • That's a good point. I know there are several Windows 10 KB's out there and I want to kill them all. Thanks!
Please log in to comment
Answer this question or Comment on this question for clarity