Totally understand, just looking for an average was all. From: [email protected] [mailto:[email protected]] On Behalf Of Ryan Sent: Wednesday, May 27, 2015 10:54 AM To: [email protected] Subject: Re: [mssms] RE: Average package\application size
For applications, the content size is the content of all DTs added together even if they reference the same folder. It can get a bit misleading if you have multiple DTs of the same large app, like Office. On Wed, May 27, 2015 at 9:46 AM, Daniel Ratliff <[email protected]<mailto:[email protected]>> wrote: 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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Michael Mott Sent: Wednesday, May 27, 2015 10:24 AM To: [email protected]<mailto:[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<tel:734-790-6643> INTL : +44 208 326 9128<tel:%2B44%20208%20326%209128> Google Voice : 734-265-0488<tel: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<tel:%2B44%280%29%202083269015> (UK) or +1 866 592 4214<tel:%2B1%20866%20592%204214> (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.
