Need K1000 report for missing Office and Visual Studio Service Packs
I need to create a report that will display all machines that do not have the newest office and visual studio service packs installed.
I am no SQL whiz so I am putting together what I can, from what I find here. So far this is what I have. This report will list all machines that are missing OS patches. How do I fine tune this to only display what I am looking for?
Thanks in advance!
SELECT PP.TITLE AS DISPLAY_NAME, M.NAME AS ComputerName FROM PATCHLINK_MACHINE_STATUS MS JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID JOIN MACHINE M ON M.ID = MS.MACHINE_ID WHERE MS.STATUS = 'NOTPATCHED' and is_app=0 /*Only select Operating System Patches*/ and Vendor like "%Microsoft%" /*Select patches from only Microsoft as Vendor*/ and identifier!="2k3sp2" /*Exclude Service Pack 2 for Server 2003*/ and identifier!="Win2K8SP2" /*Exclude Service Pack 2 for Server 2008*/ ORDER BY M.NAME
There are no answers at this time