Report: To list all ACTIVE Task Servers

Products

• IT Management Suite

Issue/Introduction

 You need to know all active Task Servers. 

Environment

ITMS 8.x, 8.7.x

Resolution

By default, there is a report that you could use under Reports > All Reports > Task Server > Status:

Task Server Summary

As well, you could use the following steps to create a custom Report:

1. Go to SMP Console > Reports > Custom Reports > Right Click > New > Report > SQL Report
2. 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
)

Additional Information

Report: To list count of assigned clients for each Task server

Report: To list all managed clients with assigned Task Server