Hello,
I need to find the Symantec Endpoint Antivirus Installation Date.
Any Altiris SQL Query or Report which can help me to find it.
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
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
Thanks. Morning I will try it.
Any Inbuilt Report?
Not that I'm aware of but you could use the query above to build an Altiris report.
Ok. Thanks Boss. I will try and if it come solution then mark it.
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
Hello HighTower,
Is there any tool which can be run the SQL Query for RO Mode?
Try the attach
http://www.querytool.com/download.html
Note- It not be recommend by symantec and no link with symantec.