/build/static/layout/Breadcrumb_cap_w.png

Report To Gather All installs of a specific software, and their versions

Hello All,

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.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: KevinG 2 years ago
Red Belt
0

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

 
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