can you not do it by site server ?

C

each agent on a client has the site server listed so will be in one of the tables

also in My portal there is a view you can choose that shows site servers and all of the computers that are assigned to them so there will be a table for that

I particularly like that view as it shows active and inactive computers reminds me of our old DS ....sigh!!!

HTH C

Hi

sorry thinking of my  own environment where all site servers are task servers and package servers

so i guees you have site servers as just package servers?

C

I have a report that can show site by subnet. Use this SQL

SELECT

*,

CASE

WHEN [IP Address] LIKE '10.190.%' THEN 'New York'
WHEN [IP Address] LIKE '10.200.%' THEN 'Glasgow'
WHEN [IP Address] LIKE '10.170.%' THEN 'Rome'
WHEN [IP Address] LIKE '192.168%' THEN '-Remote Connection - undefined'

ELSE 'Paris' END AS 'Site'

FROM vComputer vc

Hi,

go to Reports--> Notification Server Management -->Server---> Resource Reports- --> Site Servers in Subnet Report

We're going to assume you are looking for any computer assigned to Task Server X, right?  Package servers are trickier to figure out.

OR

Are you looking for an actual "site" assignment, which may include multiple Task Servers?

The two are very different rerpots.

Going with the "guess" that you're looking for systems based on Task Server assignment, there's a report you can start with (clone it) called Task Server Summary found under Reports \ Task Server \ Status.  The essence of the SQL (minus security) looks like this:

select vts.[ResourceGuid], vc.[Name] as 'Server Name', cts.[Build], ( select count(*) 
from [dbo].[Inv_Client_Task_Resources] ctr
where ctr.[ClientTaskServerGuid] = cts.[ClientTaskServerGuid] ) as 'Client Count',
vc.[IP Address] as [IP Address], vc.[Domain], vc.[OS Name] as [OS Name]
from [dbo].[vActiveTaskServiceComputers] vts
join [dbo].[vComputer] vc on vc.[Guid] = vts.[ResourceGuid]
join [dbo].[Inv_Client_Task_Servers] cts on cts.[_ResourceGuid] = vts.[ResourceGuid]

select vc1.Name "Client", vc2.Name "Server"
from vComputer vc1
join Inv_client_task_resources ctr on ctr._ResourceGuid = vc1.Guid
join vComputer vc2 on vc2.Guid = ctr.ClientTaskServerGuid

I'm actually looking for a report for "These are the clients in X site, and they're connected to Y task server".

I'm running the Reset Client Task Agent task daily but I still have many systems that don't connect to their appropriate server so I'd use this info for troubleshooting agents.

Thanks!

High Tower, half of what you're looking for is above in my previous post - that is, what task server you're connected to.

Sonic, there's a fundamental problem with what you're asking for, though it can be done.

Sort of.

The simple truth is: we don't actually assign computers to sites.  YOU can do so through "manual site assignments" and we have a stored procedure that lookst that up.  But we don't.

We let you define a site by subnet range.

When a client computer requests something that has site boundaries (e.g. package download) we look at the subnet for that client, query for what package servers service that subnet based on their site assignments, and deliver a list accordingly.  The client is not actually "in" the site per-se.

So the report is going to be interesting.

You'll have to query for all subnets in a site, then match all computers based on that subnet list, and quite frankly, it'll be a slow report if you don't also do something like build a stored procedure and/or views.

CAN it be done?  Yes.  I'd sort of like to toy with it.  But it's not out-of-the-box, because the product frankly doesn't care, so we don't track it already.

I hope that makes sense.  We'll see what we can do - the community and I.  :D

SonicGT, did my previous post give you the info that you were looking for?

No SQL expert but how about

SELECT
   vc.Guid AS ComputerGuid,
   vc.Name AS ComputerName,
   vs.Guid AS SiteGuid,
   vs.Name AS SiteName
FROM vComputer vc
   INNER JOIN ResourceAssociation sc
      ON (sc.ResourceAssociationTypeGuid = '5E8E3C61-A80C-4b0a-A228-DBF97607CEE4' --Computer To Site
         AND sc.ParentResourceGuid = vc.Guid)
INNER JOIN vSite vs
      ON vs.Guid = sc.ChildResourceGuid -- bind Computer to Site
WHERE vc.IsManaged = 1 AND LOWER(vs.Name) LIKE LOWER('%') -- any Site