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

Products

• IT Management Suite
• Task Server

Issue/Introduction

 You want to know the count of assigned clients for each Task server in your environment.

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 view task server with Count of assigned clients

select cts._ResourceGuid, vc.[Name] as 'Server Name', cts.[Build], ( select count(*)

from [dbo].[Inv_Client_Task_Resources] ctr (nolock)

inner join [dbo].[vComputer] vc on vc.[Guid] = ctr._ResourceGuid

where ctr.[ClientTaskServerGuid] = cts.[ClientTaskServerGuid] ) as 'Client Count',

vc.[IP Address] as [IP Address], vc.[Domain], vc.[OS Name] as [OS Name]

from Inv_Client_Task_Servers cts (nolock)

inner join [dbo].[vComputer] vc on vc.[Guid] = cts._ResourceGuid

where vc.IsManaged =1

Additional Information

Report: To list all managed clients with assigned Task Server

Report: To list all ACTIVE Task Servers