https://www-secure.symantec.com/connect/forums/installed-software-query
DouglasDunphy shared comment
Reports>All Reports>Discovery and Inventory>Cross-Platform>Software/applications>Software. In this folder are two reports:
Installed Software
Installed Software by Computer
If you want raw SQL instead:
Select arp.[DisplayName], arp.[DisplayVersion], Count(*)
from Inv_AddRemoveProgram arp
Where arp.[DisplayName] like '%Adobe%'
Group by arp.[DisplayName], arp.[DisplayVersion]
Replace "Adobe" in the query above with whatever product name you want. You can include "or" statements to add products:
Select arp.[DisplayName], arp.[DisplayVersion], Count(*)
from Inv_AddRemoveProgram arp
Where
arp.[DisplayName] like '%Adobe%'
or
arp.[DisplayName] like '%Microsoft%Office%'
or
arp.[DisplayName] like '%Adobe%'
Group by arp.[DisplayName], arp.[DisplayVersion]