Client Management Suite

 View Only

  • 1.  find the date

    Posted Jul 03, 2014 01:16 AM

    Any of the query in altiris which can give the installation date of any of software which i require?



  • 2.  RE: find the date
    Best Answer

    Posted Jul 03, 2014 01:20 AM

    Check this

    Query - 1

    SELECT

    vc.Name,

    vc.[OS Name],

    arp.DisplayName,

    arp.DisplayVersion,

    arp.InstallDate

    FROM

    vComputer vC JOIN

    Inv_AddRemoveProgram ARP ON vC.Guid = ARP._ResourceGuid

    Where

    DisplayName like 'Symantec Endpoint Protection'

    ORDER BY vc.Name ASC

    Query - 2

    SELECT sci.Name, inst.InstallDate
    FROM vRM_Software_Component_Item sci
    JOIN Inv_InstalledSoftware inst
       ON inst._SoftwareComponentGuid = sci.Guid
    WHERE LOWER(sci.Name) LIKE '%Symantec Endpoint Protection%'

    Note - Change the name of software according to your requirement.

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