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]> 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]] *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] <[email protected]>* | 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. > >
