Client Management Suite

Hi everyone,

We are looking for the SQL tables that house the information for a client's current task server and or package server.  We want to do a query that returns only those clients in which the Task Server GUID and Package Server GUID are matching values. 

If you have such a query, I would appreciate the use of it!

Thanks!

jms,

You could use the inv_cleint_task_resource table to give you the info you are looking for ..

using resource manager to get the table name and data you could write a query that gives you the results you are looking for.

 

 

 

use a sql query as such to get Task Servers and their registered Task clients

select
   c.Name as Computer
   ,c.[OS Name]
   ,ts.Name as [Task Server]
   ,tr.IsActive
   ,tr.HasTaskAgent
  ,tr.LastRegistered
from vComputer c
join Inv_Client_Task_Resources tr
on tr._ResourceGuid = c.Guid
join vComputer ts -- join to get the task server
on ts.Guid = tr.ClientTaskServerGuid
order by ts.Name, c.Name

 

Hi WDRAIN1

Very useful, now we need to be able to marry that data up with a similar query for a client's package server.  We are looking to include into a filter only those machines that have a matching Task Server and Package Server.

Any ideas?

Clients don't have a Package Server as such, they can download different packages from different Package Servers, AFAIK they decide on a download by download basis.

Clients should download from the package server they are assigned to in sites and services...based on their IP and the subnet assigned to a particular package server. Otherwise the clients would always be downloading over the WAN and not from the local package server as each site has in our infrastructure. With that said, I would assume that information would be stored and dynamically changed as the client subnet changes. I am looking for the table that would report that data. Thanks!

jms97

the Evt_AeX_SWD_Package table has the client package download source aka Package Server and the package.

You could you use this table to find out what site server a client downloaded it's package.