How to report all altiris agents installed

book

Article ID: 181153

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
How to report all altiris agent installed (including all solutions sub-agents) ?

Answer
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