Report: To list all managed clients with assigned Task Server


Article ID: 181476


Updated On:


Management Platform (Formerly known as Notification Server) Task Server




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