Hi
You can find the report of all installed software from Altiris at mention path
Reports > Discovery and Inventory > Inventory > Cross-platform Software/Applications > Software > Installed Software
You can find the particular software using % sign
eg -DisplayName LIKE 'Adobe Flash Player 10%
https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71
SQL Query
SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department
FROM vComputer vc
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
ON vc1.Name = vc.Name
INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
INNER JOIN vUser vu ON vc.[User] = vu.Name
WHERE arp.DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1