Fun little SQL query to get the results.
select pkg.PackageType [Type Number],
case pkg.PackageType
when '0' then 'Package'
when '3' then 'Driver Package'
when '4' then 'Task Sequene'
when '5' then 'Software Update Group'
when '257' then 'OS image'
when '258' then 'Boot image'
when '8' then 'Application'
end [Type Name], AVG(psrs.SourceSize)/1024 [Avg size in MB],
count(*) [Count]
from v_PackageStatusRootSummarizer PSRS join
v_package pkg ON psrs.PackageID = pkg.PackageID
group by pkg.PackageType
order by PackageType
and the results are in!
Type Number
Type Name
Avg size in MB
Count
0
Package
270
1522
8
Application
277
108
Daniel Ratliff
From: [email protected] [mailto:[email protected]] On
Behalf Of Michael Mott
Sent: Wednesday, May 27, 2015 10:24 AM
To: [email protected]
Subject: [mssms] Average package\application size
The title is a bit misleading, but what would you average out a typical CM shop
to have as an average package size? 500mb? 1gb? 2gb?
I'm ready for the crazy comments!
Michael Mott | Solutions Engineer - MI and OH
1E | Empowering Efficient IT
Mobile: 734-790-6643
INTL : +44 208 326 9128
Google Voice : 734-265-0488
[email protected]<mailto:[email protected]> | www.1e.com<http://www.1e.com/>
Facebook<http://www.facebook.com/1eglobal> |
Twitter<https://twitter.com/1e_global/> |
YouTube<http://www.youtube.com/1enews> | Blogs<http://blogs.1e.com/> |
RSS<http://blogs.1e.com/index.php/feed/>
Please consider the environment before printing this e-mail
________________________________
Legal Notice: This email is intended only for the person(s) to whom it is
addressed. If you are not an intended recipient and have received this message
in error, please notify the sender immediately by replying to this email or
calling +44(0) 2083269015 (UK) or +1 866 592 4214 (USA). This email and any
attachments may be privileged and/or confidential. The unauthorized use,
disclosure, copying or printing of any information it contains is strictly
prohibited. The opinions expressed in this email are those of the author and do
not necessarily represent the views of 1E Ltd. Nothing in this email will
operate to bind 1E to any order or other contract.
The information transmitted is intended only for the person or entity to which
it is addressed
and may contain CONFIDENTIAL material. If you receive this
material/information in error,
please contact the sender and delete or destroy the material/information.
