/build/static/layout/Breadcrumb_cap_w.png

K1000 Report to Detect Devices Missing Specific Software

Good afternoon Ninjas! 

I'm new to KACE, and not very familiar with SQL, but i wanted to see if i could get some help creating a KACE Report to detect & list devices that are missing a specific piece of software. 


Thank you!

-josh


0 Comments   [ + ] Show comments

Answers (1)

Posted by: IgorAngelini 4 months ago
Second Degree Blue Belt
0

Try:


SELECT MACHINE.ID AS TOPIC_ID,
       MACHINE.NAME AS SYSTEM_NAME
       
FROM MACHINE

LEFT JOIN MACHINE_SOFTWARE_JT MSJ
     ON   MSJ.MACHINE_ID = MACHINE.ID
LEFT JOIN SOFTWARE
     ON   SOFTWARE.ID = MSJ.SOFTWARE_ID


WHERE MACHINE.ID NOT IN ( SELECT MACHINE.ID

                      FROM MACHINE

                      LEFT JOIN MACHINE_SOFTWARE_JT MS
                           ON   MS.MACHINE_ID = MACHINE.ID
                      LEFT JOIN SOFTWARE S
                           ON S.ID = MS.SOFTWARE_ID

                      WHERE S.DISPLAY_NAME LIKE "%FIREFOX%"
                      AND   S.IS_PATCH = 0
                      GROUP BY MACHINE.ID
                    )

GROUP BY MACHINE.ID



This can be used as a smart label

 
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