Hi, running Altiris 7.1. Need to create a report that list computers and the managed software installed on them.
Ideally need a report that lists a computer and detials the managed osftware installed and the cost of the software, thereby providing a cost report.
thanks
SELECT vc.Guid,vc.Name, arp.DisplayName,arp.DisplayVersion
FROM vComputer vc
JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid
WHERE DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1
Thank you, i did eventunally get a report but it was a lot more complicated than your SQL (which is better),I have amended it to take into account custom fields we have, thank you