Today I had to create a report in ConfigMgr to list total number of packages that have been assigned to each Distribution Point. The SQL query is rather simple, a one-liner. Here’s the query:
select ServerNALPath, COUNT (PackageID) As PackageCount from v_DistributionPoint group by ServerNALPath order by PackageCount
This query works on both ConfigMgr 2007 and 2012.
ConfigMgr 2007 Report:
ConfigMgr 2012 Report: