Report: To list all managed clients with assigned Task Server

Article:HOWTO84983  |  Created: 2013-07-18  |  Updated: 2013-07-18  |  Article URL http://www.symantec.com/docs/HOWTO84983
Article Type
How To



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

 

 



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


Terms of use for this information are found in Legal Notices