Client Management Suite

I recently had an issue where some clients weren't getting updates/software. When I checked the package server I noticed that about a dozen or so new packages were stuck at 'retrying download' - after restarting the agent it picked up again. Is there any way to get alerts on this or generate reports of package status rather than relying on users telling me?

As solution for this, you need to create an Automation policy in SMP Console and specify there SQL Query which will determine latest "retry download" event of packages per Package Server and set rule to trigger an alert via send email task to appropriate person.
 

Hi,

Attached is a report i used in 6.x it should still work.  You can use the modify the query to meet your needs.

Here is the sql to find the package status

SELECT DISTINCT vc.Name as 'Name' from vComputer vc
       JOIN SWDPackageServer ON vc.Guid = SWDPackageServer.PkgSvrId

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, p.PackageId

Attachment(s)

Package Server Pending Packages.xml   4 KB 1 version

thanks - that will help