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