SCCM SQL Query to Find Package Size Details | ConfigMgr

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.
SCCM SQL Query to Find Package Size Details | ConfigMgr
SCCM SQL Query to Find Package Size Details | ConfigMgr

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.

Patch My PC

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.…

4 thoughts on “SCCM SQL Query 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.