/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Is there a way to use the K1000 patch management feature to detect KB3035583?

03/24/2016 1225 views
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:
0 Comments   [ + ] Show comments

Comments


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
Red Belt

  • Awesome, thanks, rockhead that's exactly what I needed to know!

All 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!

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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