Listing 'Pending Packages' for Package Servers on Altiris Console

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Problem

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.