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
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe
7.5, 7.1.2 MP1
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
This will clear the history and restart the chat.