Daily Archives: 20/08/2013

ConfigMgr Report: Total Number of Packages Per Distribution Point

Written by Tao Yang

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:

image

ConfigMgr 2012 Report:

image