SCCM report total number of packages targeted to DP


Full Detials :

SELECT v_Package.PackageID, Name,    v_DistributionPoint.LastRefreshTime    
FROM v_Package INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID
WHERE v_DistributionPoint.ServerNALPath LIKE '%DPNAME%'

Where DPNAME is Distribution point server name

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.