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

Patch My PC

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.
SCCM SQL Query Quick Way to Find Package Size Details | ConfigMgr - Fig.1
SCCM SQL Query Quick Way to Find Package Size Details | ConfigMgr – Fig.1

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.

Adaptiva

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.

4 thoughts on “SCCM SQL Query Quick Way to Find Package Size Details | ConfigMgr”

  1. 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”.

    Reply
  2. 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 ‘‘’.

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.