Is there a SQL query that can return a list of all computers with specific software installed?
ITMS 8.x
Custom query needed
The following query is provided as an example and is not supported by Broadcom Technical Support:
Select Inv_AddRemoveProgram.DisplayName, Inv_AddRemoveProgram.DisplayVersion, Inv_AddRemoveProgram.InstallDate, vComputer.Name
From Inv_AddRemoveProgram
INNER JOIN vComputer on Inv_AddRemoveProgram._ResourceGuid=vComputer.Guid
Where DisplayName like 'Microsoft Office';
Note: Please change the "Microsoft Office" in the script above to the software you want to search.