Client Management Suite

 View Only
  • 1.  software installation report

    Posted Oct 10, 2014 01:43 AM

    I am having the idea to check the report of software but it can't be show me the installation date of the software which i require to confirm for the actual installation done on what date.

    Altiris 7.1



  • 2.  RE: software installation report
    Best Answer

    Posted Oct 10, 2014 01:48 AM

    Check the thread

    https://www-secure.symantec.com/connect/forums/report-show-software-install-date

    https://www-secure.symantec.com/connect/forums/report-installed-software-products-and-install-date

    ##edit##

    SELECT vc.Name, sp.Name, inst.InstallDate

    FROM vRM_Computer_Item vc

    JOIN Inv_InstalledSoftware inst

       ON inst._ResourceGuid = vc.Guid

       AND inst.InstallFlag = 1

    JOIN ResourceAssociation ra

       ON ra.ChildResourceGuid = inst._SoftwareComponentGuid

       AND ra.ResourceAssociationTypeGuid = '9D67B0C6-BEFF-4FCD-86C1-4A40028FE483'

    JOIN vSoftwareProduct sp

       ON sp.Guid = ra.ParentResourceGuid

    ORDER BY vc.Name ASC

     



  • 3.  RE: software installation report
    Best Answer

    Posted Oct 10, 2014 01:51 AM

    Check the attach thread query to find the date of installation

    https://www-secure.symantec.com/connect/forums/altiris-sql-query-or-report



  • 4.  RE: software installation report

    Posted Oct 10, 2014 08:51 AM

    SELECT
       vc.Name,
       vc.[User],
       arp.InstallDate,
       arp.DisplayName,
       arp.DisplayVersion
    FROM vComputer vc     
      JOIN [Inv_AddRemoveProgram] arp
    on arp._ResourceGuid = vc.Guid        
    Where arp.DisplayName like '%Microsoft%Visio%Prof%'

     

    Thanks

    Suresh R