Calculating the average size of all package types in ConfigMgr

A question came up on the myITforum mssms email list this morning about the average package and application size of everyone’s ConfigMgr environment.

I look at the package size data all the time in the console, so I knew it was buried in SQL somewhere, I just had to find it. Low and behold v_PackageStatusRootSummarizer had what I needed, SourceSize represented in KB.

I threw that together in a quick SQL query and created a quick way to gather the average size of all your package types!

and the results!

Type Number Type Name Avg size in MB Count
0 Software Dist. Package 105 803
3 Driver Package 315 25
4 Task Sequence 0 46
5 Software Update Package 639 12
8 Application 277 205
257 OS image 7546 5
258 Boot image 304 3

6 thoughts on “Calculating the average size of all package types in ConfigMgr

  1. Very cool. I wrote a script recently that gets the total package size/s for any package or group of packages you choose, for any package type:

  2. Sergey Korotkov

    PackageType = 259 – “OS Upgrade Package”

  3. Newwolf

    Extra addition to your list:

    When 0 Then ‘Software Distribution Package’
    When 3 Then ‘Driver Package’
    When 4 Then ‘Task Sequence Package’
    When 5 Then ‘Software Update Package’
    When 6 Then ‘Device Settings Package’
    When 7 Then ‘Virtual Package’
    When 8 Then ‘Application package’
    When 257 Then ‘Image Package’
    When 258 Then ‘Boot Image Package’
    When 259 Then ‘OS Install Package’
    When 260 Then ‘VHD package’

    Btw, thanks sharing this.
    Makes it a little easier.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url=""> 

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