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!
select pkg.PackageType [Type Number], <br /> case pkg.PackageType<br /> when '0' then 'Package'<br /> when '3' then 'Driver Package'<br /> when '4' then 'Task Sequence'<br /> when '5' then 'Software Update Group'<br /> when '6' Then 'Device Settings Package'<br /> when '7' Then 'Virtual Package'<br /> when '8' then 'Application'<br /> when '257' then 'OS image'<br /> when '258' then 'Boot image'<br /> when '259' then 'OS Upgrade Package'<br /> when '259' Then 'OS Install Package' <br /> when '260' Then 'VHD package'<br /> end [Type Name], AVG(psrs.SourceSize)/1024 [Avg size in MB],<br /> count(*) [Count]<br />from v_PackageStatusRootSummarizer PSRS join<br /> v_package pkg ON psrs.PackageID = pkg.PackageID<br />group by pkg.PackageType<br />order by PackageType
and the results!
|Type Number||Type Name||Avg size in MB||Count|
|0||Software Dist. Package||105||803|
|5||Software Update Package||639||12|