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

Please log in to comment

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
Tenth Degree Black Belt

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

Share