Software Catalog Specific Software Machine Install Script
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
Be the first to answer this question