Client Management Suite

 View Only
  • 1.  Creating Software Installed Report

    Posted Aug 26, 2012 11:44 PM

    Hi there,

    I am a new user of Altiris and would like to create a report with the below fields:

    Search Feild as: Software name%

    Results in report as: Installed Software Name, User of Asset, Asset Number, Division of User

    Would someone please be able to advise the easiest way to create this report? Or a script I can paste in to a new report that would work?

    Thank you :o)

    Anthea

     



  • 2.  RE: Creating Software Installed Report



  • 3.  RE: Creating Software Installed Report

    Posted Aug 27, 2012 02:20 AM

    Hi Ashish,

    Thank you for your comment.

    I have used the below report stated in one of the forums:

    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

    I need to add in extra fields however, how do I do this? I need user name and department/division.

    Thanks

    Anthea



  • 4.  RE: Creating Software Installed Report
    Best Answer

    Posted Aug 28, 2012 10:01 AM

    How about this?

     

    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


  • 5.  RE: Creating Software Installed Report

    Posted Aug 30, 2012 01:46 AM

    When ever i use vcomputer i always make usre to use Ismanaged =1



  • 6.  RE: Creating Software Installed Report

    Posted Aug 30, 2012 10:45 PM

    That is awesome, thank you so much for your help :o)