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
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Get support for your product, with downloads, knowledge base articles, documentation, and more.
Maximize your product competency and validate technical knowledge to gain the most benefit from your IT investments.
Submit a suspected infected file to Symantec.
Report a suspected erroneous detection (false positive).
Set default language
Do you wish to save this as your future site?