MS17-010 NonCompliant report.
05/18/2017 1718 views
I am trying to get a report out of KACE K1000 that shows the devices that don't have the patches contained within MS17-010. Does anyone have a report that can give me this information?
Community Chosen Answer
Please log in to answer
Lookup to see what the KB number is for your version(s) of Windows per this article:
Then put that KB into SQL as seen below after "SOFTWARE.DISPLAY_NAME like" and run as a new report on the K1000:
LEFT JOIN KBSYS.KUID_ORGANIZATION O ON O.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION C ON C.KUID = MACHINE.KUID AND O.ORGANIZATION_ID = 1
where (((( (1 not in (select 1 from ORG1.SOFTWARE, ORG1.MACHINE_SOFTWARE_JT where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%Security Update for Microsoft Windows (KB4012212)%'))))))
Answered 05/18/2017 by: rockhead44