Find SCCM Package Size from DP Console and SQL Query

This guide covers the methods to find SCCM package size using a SQL query, DP content properties and from ConfigMgr console. You can find the package size in ConfigMgr with any of these methods.

The SCCM package size here refers to the size of applications, packages, operating system images, upgrade packages, ADR packages, boot images and much more.

You can easily find the application size or package size using the ConfigMgr console. However, the SCCM SQL query can also be used to determine the package size along with other package details.

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.

Once you know the number of applications, packages present in SCCM, you can find the size of each package. The size of the applications, boot images, operating system images and ADR packages determines the amount of space that it occupies on distribution points.

Read: Packages and Programs in Configuration Manager

How to Find Package Size from SCCM console

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

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

Note: The package size in SCCM console is shown in MB (Megabyte). You can export the package size and other details by pressing CTRL+A and CTRL+C.

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

Check the Package Size from Distribution Point Properties

You can check 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 Package size. If you have modified any content, ensure the content is redistributed to DP.

Learn: How to enable SCCM DP content validation

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

  • In the ConfigMgr console, go to Administration\Overview\Distribution Points
  • Select the Distribution Point from the list.
  • Right-click and go to properties of Distribution Point.
Check the Package Size from Distribution Point Properties
Check the Package Size from Distribution Point Properties

On the distribution point server properties window, select the Content tab. Under Deployment packages, you can find all the packages distributed to the current distribution point. Look for the Size (MB) column, and it shows the size of each SCCM package.

Check the Package Size from Distribution Point Properties
Check the SCCM Package Size from Distribution Point Properties

Use SCCM SQL Query to find the Package Size

Let’s look at the SCCM SQL query to find the package size details.

  • 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 SCCM SQL query to find the package size.
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 SCCM SQL Query to find Package Size
Use SCCM SQL Query to find Package Size

In the SQL query results, look for the SourceSize column which shows the real SCCM package size. Using the above SQL query, you can find 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 Comment