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

Read More