Report To Gather All installs of a specific software, and their versions
I'm trying to generate a report that will show all instances of a specific software, what version they are, and what machine their installed to. I'm trying to gather every version of Google Chrome currently in my KACE environment and which machines they're installed on. I've tried several different variations using both software and inventory as report categories, without success. Does anyone know which criteria I should be searching on to create this report? Thank you.
If you are familiar with SQL, you may want to look at the existing reports on the SMA to see if one meets your needs or can be modified to meet your requirements. You can email GettingStarted@quest.com to get a quote on the price to write a custom report.
This SQL was taken from the built-in report "Software Inventory By Vendor" and modified to look for Google Chrome.
Select DISPLAY_NAME, COUNT(DISPLAY_NAME) as Deployed_Count, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT)
where SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH and DISPLAY_NAME = 'Google Chrome'
GROUP BY DISPLAY_NAME
order by PUBLISHER, DISPLAY_NAME