Report that shows the "Status of Packages" for all Package Servers

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

Admins need to know what the status is for Packages across all of the Package Servers in one report.  Occasionally packages go missing, are new, or need to be re-downloaded and being able to see this information would be helpful.  

Environment

ITMS 8.x.

Resolution

A report can be created using the following SQL query to show the Package Status by Package Server:

  SELECT    vc.[Name] AS [Package Server],  
            count(pk.[Name]) AS [Package Count],  
            ps.Status AS [Status]  
    FROM    SWDPackageServer ps  
    JOIN    vComputer    vc  ON ps.PkgSvrId = vc.Guid  
    JOIN    vRM_Package_Item pk ON pk.Guid = ps.PackageId  
    WHERE   pk.ProductUninstalled = 0  
    GROUP BY  VC.NAME, ps.Status
    Order by [Package Server]

Another report can be created using the following SQL query showing the Packages that are NOT READY:

  SELECT    vc.[Name] AS [Package Server],  
            ps.Status AS [Status]  , pk.Name, pk.Description, pk.ModifiedBy, pk.ModifiedDate, pk.Guid
    FROM    SWDPackageServer ps  
    JOIN    vComputer    vc  ON ps.PkgSvrId = vc.Guid  
    JOIN    vRM_Package_Item pk ON pk.Guid = ps.PackageId  
    WHERE   pk.ProductUninstalled = 0  
    and Status != 'Ready'
    Order by Name, [Package Server]

If we have any questions about the Status of a Package, you can run the following built-in Report that shows the Name of the Package and the Package Server it is on with that status:

 All Reports > NS Management > Server > Package Status by Package Server