Report: To list all managed clients with assigned Task Server

Article:HOWTO84983  |  Created: 2013-07-18  |  Updated: 2013-07-18  |  Article URL
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 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



Article URL

Terms of use for this information are found in Legal Notices