ITMS Administrator Group

Hello All,

I was looking for a Report which displays the computernames and from which Package servers they are trying to download the packages.

In my environment there are issues where some computers are downloading packages from some other package servers (Site Servers)

i went through https://www.symantec.com/connect/forums/package-server-reports but unable to get the required answer.

Thanks

I'm not sure that such data is easily available because a client can download different packages from different servers depending on the speed tests it does when it gets each package info.

You might be better off finding one of the problem clients using the Agent Diagnostics:

"How to install or uninstall the Altiris Agent Diagnostics dll (AeXAgentDiagnostics.dll) for the Altiris Agent?"

http://www.symantec.com/docs/HOWTO2057

The database does hold event records for package downloads assuming that event is enabled.  The challenge is that there can be many records since it typically takes many download "events" to complete one package download to one machine.  However, I have found the need to report on this data but I typically filter it down in some way.  You can look at the events view of an individual machine in resource manager to see where it has been historically downloading packages from.   The below sql is for a report I use to show where every machine downloaded a particular package from.  This may be more what you are looking for.  

Note: For this report I added a parameter and drop down selector so you can choose a package before you run the report but for the purpose of this example, I hard coded an example of Java in to the SQL.  

SQL: 

-- v2014_04_10 Package Download Activity for Package X 
SELECT DISTINCT
    vc.Guid [_ItemGuid],
    vc.[Name] [Computer Name],
    vc.[IP Address],
    vc.[User] [Primary User],
    ps.PackageName [Package Name], 
    ps.status [Download Status], 
    ps.URL, 
    ps.[_EventTime],
    vc.Domain,
    (    SELECT TOP 1 CC.[StartTime] FROM [evt_ns_client_config_request] CC
        WHERE CC.[ResourceGuid] = vc.[Guid]
        ORDER BY CC.[StartTime] DESC
    ) AS [Last Config Request],
    sn1.[Manufacturer],
    sn1.[Model],
    vc.[OS Name]

FROM vComputer vc                                 
    LEFT JOIN vHWComputerSystem sn1 ON  sn1.[_ResourceGuid] = vc.Guid 
    LEFT JOIN Inv_HW_Chassis cha ON cha.[_ResourceGuid] = vc.[Guid]    
    --JOIN Inv_AeX_SWD_Package_Summary ps on ps._ResourceGuid = vc.Guid and ps.PackageName like '%PkgName%'
    JOIN Inv_AeX_SWD_Package_Summary ps on ps._ResourceGuid = vc.Guid and ps.PackageName = 'Java 8 Update 101'
    
WHERE vc.[IsManaged] = 1

ORDER BY ps.[_EventTime] DESC

I try and avoid collecting this information, it's a significant extra increase on event processing for the Notification Server.

I agree, it does put a burdon on the NS and database.  However, we use this information quite a bit for troubleshooting and reporting.  When a bug in one of the hot fixes earlier this year caused the download events to stop working, we found we really missed having it.