Ran that... for us,
Package: 275MB Applications: 224MB
On Wednesday, May 27, 2015 9:56 AM, Ryan <[email protected]> wrote:
Why? For every large app like Office or SolidWorks there are 10 smaller apps
like 7-zip, VLC, Flash, etc.
On Wed, May 27, 2015 at 9:52 AM, Michael Mott <[email protected]> wrote:
WOW! It’s much less than I thought! From: [email protected]
[mailto:[email protected]]On Behalf Of Daniel Ratliff
Sent: Wednesday, May 27, 2015 10:46 AM
To: [email protected]
Subject: [mssms] RE: Average package\application size 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 PSRSjoin v_package pkgON psrs.PackageID=
pkg.PackageIDgroupby pkg.PackageTypeorderby 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 OH1E | Empowering Efficient
ITMobile: 734-790-6643INTL : +44 208 326 9128Google Voice :
[email protected]| www.1e.com Facebook | Twitter |YouTube |Blogs
|RSSPlease 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.
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.
