Please use the following steps to create a custom Report
SMP Console > Reports > Custom Reports > Right Click > New > Report > SQL Report Paste the following SQL query within Parameterised Query Section
-- All Active Task Servers. select aaca._ResourceGuid, vcx.Name, vcx.[IP Address], aaca.[Agent Name], aaca.[Product Version], aaca.[Build Number], aaca.[Install Path] from Inv_AeX_AC_Client_Agent aaca (nolock) inner join vComputerEx vcx on vcx.Guid = aaca._ResourceGuid where aaca.[Agent Name] = 'Altiris Client Task Server Agent' and aaca._ResourceGuid in ( select ats.ResourceGuid ActiveGUID from vActiveTaskServiceComputers ats )
Related KB Title: Report listing site servers where package services have failed to install http://www.symantec.com/docs/HOWTO61268
Title: Report: To list all ACTIVE Package Servers HOWTO61270
Title: Report: To list count of assigned clients for each Task server.
Title: Report: To list all managed clients with assigned Task Server
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe
7.1.2, 7.0 MR4
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
This will clear the history and restart the chat.