Asset Management Suite

 View Only
  • 1.  Create a report: List managed software on a computer (Altiris 7.1)

    Posted Feb 04, 2012 02:19 PM

    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



  • 2.  RE: Create a report: List managed software on a computer (Altiris 7.1)

    Posted Mar 01, 2012 02:26 AM

    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 



  • 3.  RE: Create a report: List managed software on a computer (Altiris 7.1)

    Posted Mar 02, 2012 08:51 AM

    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