3 Proven Methods to Find SCCM Package Size Details

This article discusses multiple methods to find SCCM package size details, including using a SQL query, DP content properties, and the ConfigMgr console. The SCCM package size refers to the size of applications, packages, operating system images, upgrade packages, ADR packages, boot images, and much more.

In some cases when you are asked to find the packages that are occupying a lot of space on SCCM server, you will require a way to determine the size of packages. Large organizations that regularly use SCCM to deploy applications will have a large count of packages in the setup. Finding the count and size of packages becomes important during regular audits.

With the methods described in this post, you will be able to determine the count of all the packages and the size of each package in SCCM (ConfigMgr). Once you determine the package size, you can then decide whether you still need that package or if it can be deleted. Deleting a package saves disk space on SCCM servers. You can also use the SCCM content library cleanup tool to remove orphaned content from distribution points.

PatchMyPC HorizontalAD
Patch My PC Sponsored AD

Methods to determine the Package Size in SCCM

There are multiple ways to determine the size of packages in SCCM. We will use the following methods to find package size in SCCM:

  • Find the package size from the ConfigMgr console.
  • Determine the size of packages from DP properties.
  • Use SQL query to determine the SCCM package size.

You can determine the size of packages using any of the methods listed above. Out of all the methods listed above, using the ConfigMgr console to check the package size is the easiest. If you would like to know more about the package, like its version, language, or installation status, you can use an SQL query. With a SQL query, it is also easy to list all the packages present in SCCM. Here is a nice article to list all SCCM packages using SQL query.

Read: Overview of Packages and Programs in Configuration Manager

How to Find Package Size from SCCM Console

Use the below steps to find the SCCM package size from the ConfigMgr console.

  • Launch the SCCM console.
  • Go to Monitoring\Overview\Distribution Status\Content Status.
  • The Content Status node lists all the Applications, Packages, Task Sequences, OS upgrade, Boot Images etc in SCCM.
  • Check the column named Size (MB) to get the size details of packages, applications and all the content.

In the below screenshot, we see the SCCM package size is shown in MB (megabytes). From the same screen, you can export the package details by pressing CTRL+A and CTRL+C in the SCCM console.

How to Find Package Size from SCCM console
How to Find Package Size from SCCM console

Find SCCM Package Size from Distribution Point

You can find the size of applications, packages, boot images, ADR packages, operating system images, etc. from the content tab of distribution point server properties. Any content that is distributed to a distribution point has a unique package ID and displays the actual package size. If you have modified any content, ensure the content is redistributed to DP.

Use this method only if you are certain that the content is completely distributed to the distribution point server. If the package is not available on the distribution point server, you cannot find its size and details.

Use the following steps to find SCCM package size from Distribution Point Server properties:

  • Launch the SCCM console
  • Go to Administration\Overview\Distribution Points
  • Select the Distribution Point from the list.
  • Right-click the DP and select Properties.
Find SCCM Package Size from Distribution Point Server
Find SCCM Package Size from Distribution Point Server

On the distribution point server properties window, select the Content tab. Under “Deployment Packages,” the Size (MB) column shows the size of each SCCM package. If you don’t find the package in the list, make sure the package is distributed to the DP first.

Learn: How to enable SCCM DP content validation

Find SCCM Package Size from Distribution Point Server
Find SCCM Package Size from Distribution Point Server

SQL Query to Find SCCM Package Size Details

You can use a simple SQL query to find package size details in SCCM using the following steps:

  • Launch the SQL Server Management studio (SSMS) and connect to database engine.
  • Expand Databases and right-click SCCM database and select New Query.
  • In the query window, paste and execute the below SQL query to find the package size details.
SELECT p.Name, p.Description, n.SourceCompressedSize, n.SourceSize, dp.LastRefreshTime, p.Manufacturer, p.Version, p.Language, p.SourceSite, p.PackageID, case when dp.IsPeerDP=1 then '*' else '' end as BranchDP, psd.InstallStatus
FROM v_Package p
INNER JOIN
v_DistributionPoint dp
ON
p.PackageID = dp.PackageID
LEFT JOIN
v_PackageStatusRootSummarizer n
ON
p.PackageID = n.PackageID
LEFT JOIN
v_PackageStatusDistPointsSumm psd
ON
dp.ServerNALPath=psd.ServerNALPath
AND
dp.PackageID=psd.PackageID
LEFT JOIN
v_PackageStatus ps
ON
dp.ServerNALPath=ps.PkgServer
AND
dp.PackageID=ps.PackageID
Use SQL Query to Find SCCM Package Size Details
Use SQL Query to Find SCCM Package Size Details

In the SQL query results, look for the SourceSize column, which shows the size of all the packages. Using the above SQL query, you can find the SCCM package size along with the following details.

  • Package Name
  • Description of the Package
  • Package Source Compressed Size
  • Installation Status
  • Last Refresh Time
  • Manufacturer Details
  • Package Version
  • Language
  • Source Site
  • Package ID

Leave a Reply

Your email address will not be published. Required fields are marked *

2 Comments

  1. Any idea on amending this script to point to a particular distribution point ?