How to get package size in ConfigMgr

You can use the following to get package size information in SCCM.

SELECT DISTINCT p.PackageID, p.Name, 'Source Size (MB)' = n.SourceSize/1024
FROM v_Package p
LEFT JOIN
v_PackageStatusRootSummarizer n
ON
p.PackageID = n.PackageID
ORDER BY 'Source Size (MB)' DESC;

Alternatively, you can use PowerShell command.

# Open PowerShell as Admin on SMS Provider server
$SiteCode = "PS1" # Replace PS1 with actual site code
Get-WmiObject -Namespace ROOT\SMS\site_$SiteCode -Class SMS_PackageStatusRootSummarizer | Select-Object -Property PackageID, @{Name="Package Size(M)";Expression={$_.SourceSize/1024}} |Sort-Object -Property "Package Size(M)" -Descending

References

• https://social.technet.microsoft.com/Forums/systemcenter/en-US/eb14a03b-4800-4e3f-b125-157e6f078b3b/report-to-list-all-packages-with-package-size