Client Management Suite

Need some help with what tables info could be found in for a report I am trying to do.

we have 14 sites and package servers all around. I just realized that I have not been maintaining the sites thus I have some machines over seas contacting back here to grab software. 

so I am trying to figure out what table shows what package server a machine is connected to. anyone know?

There a number of posts on connect that mention this.

• https://www.symantec.com/connect/forums/report-about-package-servers-71

There are a number of Reports you could look at in the SMP for how it gets Package information

You can get Sites from vSiteServices. 

SubNet comparison

Another option is to use IP address of the computer and see if it is in the same subnet as the Package server.

The Agents checks using the following URL

http://SMPServer/Altiris/Deployment/Agent/GetNearestPackageServerInfo.aspx?xml=""

siteType = "taskserver";
siteType = "packageserver";

strXML = "<request>" + 
"<GetNearestPackageServerInfo>" + 
"<clientIPAddress>" + clientIPAddress + "</clientIPAddress>" +
"<siteType>" + siteType + "</siteType>" + 
"</GetNearestPackageServerInfo>" + 
"</request>";

It's not a simple relationship because the Symantec Management Agent will decide which package server to use of the options the NS gives it each time it downlaods a package. So package 1 can come from one package server and package 2 from a different package server later that day if the network speeds and usage have changed.