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

Article:HOWTO84982  |  Created: 2013-07-18  |  Updated: 2013-07-18  |  Article URL http://www.symantec.com/docs/HOWTO84982
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 view task server with Count of assigned clients

select cts._ResourceGuid, vc.[Name] as 'Server Name', cts.[Build], ( select count(*)

from [dbo].[Inv_Client_Task_Resources] ctr (nolock)

inner join [dbo].[vComputer] vc on vc.[Guid] = ctr._ResourceGuid

where ctr.[ClientTaskServerGuid] = cts.[ClientTaskServerGuid] ) as 'Client Count',

vc.[IP Address] as [IP Address], vc.[Domain], vc.[OS Name] as [OS Name]

from Inv_Client_Task_Servers cts (nolock)

inner join [dbo].[vComputer] vc on vc.[Guid] = cts._ResourceGuid

 

where vc.IsManaged =1

 

 

related KBs



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

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


Title: Report: To list all ACTIVE Task Servers

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



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


Terms of use for this information are found in Legal Notices