Need to generate a K1000 report
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.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
dugullett
11 years ago
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'
