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.
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.
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.
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.
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.
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
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
- Source Site
- Package ID