ConfigMgr Report: Total Number of Packages Per Distribution Point

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:
[sourcecode language=”SQL”]
select ServerNALPath, COUNT (PackageID) As PackageCount from v_DistributionPoint group by ServerNALPath order by PackageCount
[/sourcecode]
This query works on both ConfigMgr 2007 and 2012.

ConfigMgr 2007 Report:

image

ConfigMgr 2012 Report:

image

Leave a Reply

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

%d bloggers like this: