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.
Title: Report: To list all ACTIVE Task Servers
Did this article resolve your issue?
Did this article save you the trouble of contacting technical support?
How can we make this article more helpful?
Email Address (Optional)
Login to Subscribe
Please login to set up your subscription.
Create and manage cases, manage licensing and renewals, submit threats, and enroll with Symantec Rewards.
Customer and Technical Support phone numbers and hours of operation.
User-to-user forums, blogs, videos, and other community resources on Symantec Connect.
Set default language
Do you wish to save this as your future site?