Report: To list all managed clients with assigned Task Server

Products

• Management Platform (Formerly known as Notification Server)
• Task 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

 

-- To list clients with assigned task server Name

select ctr._ResourceGuid, vc.Name, vc.[IP Address],

 vcx.Name as [Task Server], ctr.IsActive, ctr.LastRegistered

from vComputerEx vc

inner join [Inv_Client_Task_Resources] ctr (nolock) on ctr._ResourceGuid= vc.Guid

inner join vComputerEx vcx on ctr.ClientTaskServerGuid = vcx.Guid

where vc.IsManaged =1

 

Order by [task server]

 

 

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

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

Title: Report: To list all ACTIVE Task Servers

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