Client Management Suite

Greetings Everyone,

I am currently trying to generate report which would display which clients are reporting to which specific site servers.

I have done a search on the site but the closest I could come to is :

https://www-secure.symantec.com/connect/forums/queryreport-show-what-site-pc-belongs

SELECT [vc].[Guid],

vc.Name AS 'Computer Name',

vc2.Name AS 'Task Server Name',

vs.Name AS 'Site Name'

FROM [vComputer] AS [vc]

INNER JOIN [Inv_AeX_AC_TCPIP] AS [tcp] ON [tcp].[_ResourceGuid] = [vc].[Guid]

INNER JOIN [vSite] AS [vs] ON [vs].Name LIKE '%'

INNER JOIN [vSiteSubnetMap] AS [ss] ON [ss]._ResourceGuid = [vs].[Guid]

INNER JOIN [Inv_Subnet] AS [sn] ON [sn].[_ResourceGuid] = [ss].[SubnetGuid]

INNER JOIN [Inv_Client_Task_Resources] ctr on ctr._ResourceGuid = vc.Guid

INNER JOIN vComputer vc2 on vc2.Guid = ctr.ClientTaskServerGuid

WHERE

dbo.[fnIsIPInSubnet2]([tcp].[IP Address],[sn].[Subnet],[sn].[Subnet Mask]) = 1

*Credits go to HighTower for the post.

However, this has not worked for me.

Does anyone here utilize a report such as this? or perhaps an alternative to generate the same results?

Many thanks in advance.

There's built in filters showing each Task Server's clients, as a matter of good practice I run a weekly Task to reset Task Agents on all PCs in the filter for Task Agents connecting directly to the Task Server.

I think they're under Filters > Computer Filters > Task Service Filters.

For a report either use the same SQL or find a report that lets you report on Computers in a Filter.
 

Strange, I just ran it and it still works for me.

What version of SMP are you on?  7.1SP2 or 7.5? 

You say that it doesn't work... what does that mean?  No results or an error?

Brayan,

Try this. First query gives the pcs managed by Task Servers.

select distinct

ctr.[_ResourceGuid] as [PC Guid]

,vi.Name as PC

,vtr.ResourceGuid as [Task Server Guid]

,vi1.Name as [Task Server]

from [dbo].[Inv_Client_Task_Resources] ctr

join [vActiveTaskServiceComputers] vtr on ctr.[ClientTaskServerGuid] = vtr.ResourceGuid

join vItem vi on vi.Guid = ctr._ResourceGuid

join vItem vi1 on vi1.Guid = vtr.ResourceGuid

where ctr.[HasTaskAgent] = 1

This query gives you number of clients managed by Task Server

select vi.Name as [Task Server], count (distinct ctr.[_ResourceGuid]) as [PC counts] from [dbo].[Inv_Client_Task_Resources] ctr

join [vActiveTaskServiceComputers] vtr on ctr.[ClientTaskServerGuid] = vtr.ResourceGuid

join vItem vi on vi.Guid = vtr.ResourceGuid

where ctr.[HasTaskAgent] = 1

group by vi.Name

The queries started from the code used by system filters in Task Service Filters folder.

Mark as solution if found helpful.

Tomasz