SCCM report total number of packages targeted to DP
Posted by Eswar Koneti on June 1st, 2012
Full Detials : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/cdfc6114-09d8-4e85-a51a-ca279a36454a
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