SQL Query : All Package Statuses for a specific DP

This query will allow you to report on the installation status of all packages on a specified Distribution Point.

SELECT Name,
    Description,
    v_DistributionPoint.LastRefreshTime,
    Manufacturer,
    Version,
    Language,
    v_Package.SourceSite,
    v_Package.PackageID,
     case when v_DistributionPoint.IsPeerDP=1 then '*' else '' end as BranchDP
 FROM v_Package
 INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID
 WHERE v_DistributionPoint.ServerNALPath LIKE '%BLRSCCM10001%'
 Order by Name

Sample Output

Related posts

2 Thoughts to “SQL Query : All Package Statuses for a specific DP”

  1. gwyn

    excellent, and i used this earlier 😉

    1. Jon Moss

      Thanks Gwyn. Really appreciate your visit and comment. Cheers buddy.

Leave a Comment