Video Screencast Help

Create a report: List managed software on a computer (Altiris 7.1)

Created: 04 Feb 2012 | 2 comments

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

Comments 2 CommentsJump to latest comment

CBZ9104's picture

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 

markab's picture

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