How Do I Create A Collection of Computers with Certian Software Installed?

0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


You can do this through the GUI by finding the items you wish to include in the various lists, but to get there directly choose "Custom SQL" and enter the following query:
select.asw.[File Name], asw.[ProductName] as 'Product Name', asw.[ProductVersion] as 'Product Version', asw.[Manufacturer] from inv_aex_sw_audit_software asw where asw.[File Name] like 'msaccess.exe'
This will look in your software audit tables for all systems that are reported to contain the msacces.exe file. You can easilly modify this to find all installed instances of a program regardless of how it was installed or if it appears in Add/Remove programs.
Answered 06/11/2006 by: bkelly
Red Belt

Please log in to comment