Report: To list all ACTIVE Task Servers

book

Article ID: 180788

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

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.

http://www.symantec.com/docs/HOWTO84982

 

Title: Report: To list all managed clients with assigned Task Server

http://www.symantec.com/docs/HOWTO84983