Report: To list all managed clients with assigned Task Server

Products

• IT Management Suite
• Task Server

Issue/Introduction

 You want to know all managed clients with assigned Task Server

Environment

ITMS 8.x, 8.7.x

Resolution

You could use the following steps to create a custom Report:

1. Go to SMP Console > Reports > Custom Reports > Right Click > New > Report > SQL Report
2. 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]

Additional Information

Report: To list count of assigned clients for each Task server

Report: To list all ACTIVE Task Servers