Hey,

Still trying to learn SQL scripting for Kace reports.  Wanted to know if someone can assist with generating a report within Kace to display Windows 7 machines missing SP1? 

 

Thanks. 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

3

Not sure what all other info you need? Try this though.

SELECT NAME, IP, USER_LOGGED

FROM MACHINE M

WHERE OS_NAME LIKE 'MICROSOFT WINDOWS 7%'

AND SERVICE_PACK != 'SERVICE PACK 1'
Answered 08/14/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity