/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Help with a Report on K1000 6.4

06/16/2016 525 views
Trying to get help creating a report for devices with Office 2010 SP2 missing - Service Pack 2 for Microsoft Office 2010 32-Bit Edition (KB2687455)

Any help would be great
0 Comments   [ + ] Show comments

Comments


All Answers

0
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE  WHERE (((not exists  (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME = 'Service Pack 2 for Microsoft Office 2010 (KB2687455) 32-Bit Edition')) ))  
Answered 06/16/2016 by: rockhead44
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ