Finding out how many are downloading packages from a Package Server and the location where the Package Server is downloading its packages from

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
How can I find out how many resources are downloading packages from a particular Package Server, as well as the location where the Package Server is downloading its packages from?

Answer
This query will give you a detailed result set on which resources have downloaded what packages from which Package Server or Notification Server, which can be used for local reports:

SELECT i.[Name],sp._EventTime,sp.EventType,sp.PackageName,
sp.Url,sp.DownloadNumber,sp.TransferRate,sp.Time,sp.Status
FROM Item i JOIN Evt_AeX_SWD_Package sp ON i.Guid = sp._ResourceGuid
WHERE sp.Status = 'Complete'
ORDER BY sp.Url

This query will give you a detailed result set on which resources have downloaded what packages from which Package Server or Notification Server, which can be used for global reports:

SELECT i.[Name],sps._EventTime,sps.EventType,sps.PackageName,
sps.Url,sps.DownloadNumber,sps.TransferRate,sps.Time,sps.Status
FROM Item i JOIN Inv_AeX_SWD_Package_Summary sps ON i.Guid = sps._ResourceGuid
WHERE sps.Status = 'Complete'
ORDER BY sps.Url

Additional download information is available by reviewing the contents of .\Altiris\Altiris Agent\Package Delivery\<Guid>\log.xml folder