How Do I Create A Collection of Computers with Certian Software Installed?
How Do I Create A Collection of Computers with Certian Software Installed?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
bkelly
18 years ago
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.
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.