Query to report for all altiris agents installed

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

This article gives you sample queries to report on all computers with the Symantec Management Agent installed and see all solutions sub-agents, agent/plug-in versions, and agent installation paths.

Resolution

Create a new report in Altiris Console using the following query:

SELECT     dbo.vComputer.Guid, dbo.vComputer.Name, dbo.Inv_AeX_AC_Client_Agent.[Agent Name],    
                      dbo.Inv_AeX_AC_Client_Agent.[Product Version], dbo.Inv_AeX_AC_Client_Agent.[Build Number], dbo.Inv_AeX_AC_Client_Agent.[Install Path]   
FROM         dbo.vComputer INNER JOIN   
                      dbo.Inv_AeX_AC_Client_Agent ON dbo.vComputer.Guid = dbo.Inv_AeX_AC_Client_Agent._ResourceGuid   
ORDER BY dbo.vComputer.Name,dbo.Inv_AeX_AC_Client_Agent.[Agent Name], dbo.Inv_AeX_AC_Client_Agent.[Product Version] 

The following query is useful to find specific agents, for example when you want to find agents installed from solutions that have been removed from the NS server before removing the agents from the machines, it filters out "known" agents. You must modify it to suit your needs.

SELECT     dbo.vComputer.Guid, dbo.vComputer.Name, dbo.Inv_AeX_AC_Client_Agent.[Agent Name],  
                      dbo.Inv_AeX_AC_Client_Agent.[Product Version], dbo.Inv_AeX_AC_Client_Agent.[Build Number], dbo.Inv_AeX_AC_Client_Agent.[Install Path] 
FROM         dbo.vComputer INNER JOIN 
                      dbo.Inv_AeX_AC_Client_Agent ON dbo.vComputer.Guid = dbo.Inv_AeX_AC_Client_Agent._ResourceGuid 
WHERE     (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'Altiris Agent') AND (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'%Carbon Copy%') 
                       AND (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'%Inventory%') AND  
                      (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'%Software Delivery%') AND  
                      (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'%eXpress AClient%') AND  
                      (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'%Software Update%') AND  
                      (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'%eXpress NS Client%') AND  
                      (dbo.Inv_AeX_AC_Client_Agent.[Agent Name] NOT LIKE N'%Package Agent%') 
ORDER BY dbo.Inv_AeX_AC_Client_Agent.[Agent Name], dbo.Inv_AeX_AC_Client_Agent.[Product Version], dbo.vComputer.Name