SCCM SQL Query Quick Way to Find Package Size Details | ConfigMgr
Let’s check the SCCM SQL Query Quick Way to Find Package Size Details | ConfigMgr.
The following query provides you with more details about the packages/applications.
You can quickly look at the package size and plan the distribution/redistribution of packages.
You can refer to the following post to get the details without using SQL query/custom report to find the package size details – The Best Way To Find Package Size From ConfigMgr Console | SCCM | Configuration Manager HTMD Blog
Table of Contents
SQL Query to Find Package Size
The main idea of this SQL query is to find the package size details. This also helps you find all the other valuable information about each package, application, etc., from your environment.
- Open the SQL Management Studio.
- Connect your Database Engine.
- Right-click on your database CM_XXX and click on ‘New Query.’
- Copy the following SQL query to find the package size report and other details.
- Click on the Execute button.
- Best Place to Find ConfigMgr Package IDs in Admin Console.
- SCCM SQL Query to Find Package Size Details | ConfigMgr
- Install ConfigMgr Client Using Client Push Installation Method SCCM
SQL Query – SCCM Application 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
NOTE! Full credits to the query author. I can’t trace the author of the query.
Resources
We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.
Author
Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.
Hi, Thanks for sharing this but I can't make this to work. I get the following error:
Msg 137, Level 15, State 2, Line 24
Must declare the scalar variable “@ID”.
Msg 137, Level 15, State 2, Line 30
Must declare the scalar variable “@__filterwildcard”.
Msg 156, Level 15, State 1, Line 32
Incorrect syntax near the keyword 'else'.
Msg 137, Level 15, State 2, Line 34
Must declare the scalar variable “@__filterwildcard”.
Try putting “ID” as Prompt Properties “NAME” and “TEXT”
Hi Anoop, Thanks for sharing the query. I am also getting the same error,
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘‘’.
Msg 137, Level 15, State 2, Line 30
Must declare the scalar variable “@__filterwildcard”.
Msg 102, Level 15, State 1, Line 31
Incorrect syntax near ‘‘’.
Msg 102, Level 15, State 1, Line 33
Incorrect syntax near ‘‘’.
Please try this table:-
select * from v_PackageStatusRootSummarizer