/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Software Catalog Specific Software Machine Install Script

08/28/2017 509 views

I am looking for an SQL script to build a report that shows specific machines with the software installed, application name, display version, IP, user logged and last sync/inventory. I have the below script that runs from the "Software" Inventory but I am needing one that runs from the "Software Catalog" Inventory. Any help is greatly appreciated!


Select MACHINE.NAME as Computer_Name,SOFTWARE.DISPLAY_NAME as Application_Name,display_version,IP, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED, LAST_SYNC from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%Firefox%' order by DISPLAY_NAME

0 Comments   [ + ] Show comments

Comments


Be the first to answer this question

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