Report: To list all managed clients with assigned Task Server

Article Id: 181476

Status: Published

Updated On: 18-07-2013 18:53

Legacy Id: HOWTO84983

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