Help with a Report on K1000 6.4
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
Any help would be great
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
rockhead44
7 years ago
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')) ))