Client Management Suite

Does anyone know of the table where I can find site or subnet info as it relates to package servers? I would like to associate a computer at a certain location and be able to grab the package server that's assigned to that location. This info is available if you go to the site settings page but I need to pull it via sql so I can run a workflow and use the package server as a variable.

 

 

7.1 Sp2 Mp1

Maybe you want to go to:

Reports  
 Notification Server Management  
 Server

Esp:

• Site Report
• Site Servers in Subnet Report
• Sites and Package Servers Report

Clone and edit them, to have a look at the SQL queries.

 

@Edit:

Screw this ... there is no SQL datasource inside ... big thanks to Mr. Murphy

try this query, Site Server access Computer select v1.Name as [Computer Name], v2.Name as [Task Server] from vComputer v1 left outer join Inv_Client_Task_Resources on v1.Guid = Inv_Client_Task_Resources._ResourceGuid left outer join vComputer v2 on Inv_Client_Task_Resources.ClientTaskServerGuid = v2.Guid If any issue pls revert.

Sorry my hard drive crashed and I'm just now getting back to this.

 

The query works but it pulls back the Task Server, in this case I need to pull back the package server. 

 

We have 3 task servers in our environment and roughly ~200 package servers at each facility. 

I don't think there is a dedicated package server, rather your agents pull the available package sources per package. So for package A you might get Server1 as your package source, but for package B you might be Server2. If you've constrained your package servers and assigned a package server to a specific site, then I suppose the easiest way is to get the package source for any of your packages and you can safely assume ALL packages will choose that same source.

I just looked at my previous comment and I worded it wrong. We have 200 separate facilities with package servers at each. Some of these have multiple subnets which complicates thingns a bit query wise. In NS6 there was a table named PackageServerServingSite that is exactly what I need. I think I'm goingn to create a view which houses this info and reference it in my query.