From the Altiris web console, how do you display a list of the 'Pending Packages' waiting to be downloaded to a Package Server (see Configuration tab, Configuration- Server Settings - Notification Server Infrastructure - Package Servers)?
Environment
NS 6.0.5287 HF19
DS 6.5.233
Cause
There do not appear to be any existing reports to display any details of the pending packages.
Resolution
Running the following SQL query will pull a list of packages which are not in 'Ready' state from the specified Package Server:
SELECT DISTINCT p.Name [Package Name], p.PackageId [PackageID], s.Status [Status]
FROM SWDPackage p
JOIN SWDPackageServer s ON p.PackageId = s.PackageId
JOIN vComputer vc on vc.Guid = s.PkgSvrId
WHERE vc.Name LIKE '%Package Server%'
AND vc.Guid = s.PkgSvrId
AND s.Status <> 'Ready'
ORDER BY p.Name
Alternatively, the attached XML report can be imported into the Console Reports.