Client Management Suite

 View Only
  • 1.  Altiris SQL Query or Report

    Posted May 30, 2013 03:03 PM

    Hello,

    I need to find the Symantec Endpoint Antivirus Installation Date.

    Any Altiris SQL Query or Report which can help me to find it.



  • 2.  RE: Altiris SQL Query or Report
    Best Answer

    Trusted Advisor
    Posted May 30, 2013 03:25 PM

    How about this?

    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



  • 3.  RE: Altiris SQL Query or Report

    Posted May 30, 2013 03:27 PM

    Thanks. Morning I will try it.

    Any Inbuilt Report?



  • 4.  RE: Altiris SQL Query or Report

    Trusted Advisor
    Posted May 30, 2013 03:28 PM

    Not that I'm aware of but you could use the query above to build an Altiris report.



  • 5.  RE: Altiris SQL Query or Report

    Posted May 30, 2013 03:32 PM

    Ok. Thanks Boss. I will try and if it come solution then mark it.



  • 6.  RE: Altiris SQL Query or Report
    Best Answer

    Posted May 31, 2013 12:07 AM

    Here you go:

    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%'

    Just replace "Symantec Endpoint Protection" with any software name to find out when it was installed...

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



  • 7.  RE: Altiris SQL Query or Report

    Posted Jun 01, 2013 01:12 AM

    Hello HighTower,

    Is there any tool which can be run the SQL Query for RO Mode?



  • 8.  RE: Altiris SQL Query or Report

    Trusted Advisor
    Posted Jun 02, 2013 10:12 PM
    I'm not familiar with that or what needs to be different.


  • 9.  RE: Altiris SQL Query or Report

    Posted Jun 03, 2013 12:19 AM

    Try the attach

    http://www.querytool.com/download.html

    Note- It not be recommend by symantec and no link with symantec.