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

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity