Let’s check SCCM SQL Query to Find Package Size Details | ConfigMgr. The following query provides you more details about the packages/applications.
SQL Query to Find Package Size
The main idea of this SQL query is to find the package size details. This also helps to find all the other useful details about each package. applications, 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 report of package size and other details.
- Click on the Execute button.
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 author of the query. I’m not able to trace the author of the query.
Resources
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is Blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about technologies like 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