I know, I was just adding that tidbit. I worked at one location that had 24 different DTs for Office based on location and if the user was logged in. The content size of that app threw off averages even though each DT referenced the same source.
On Wed, May 27, 2015 at 9:55 AM, Michael Mott <[email protected]> wrote: > 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]> > 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. > > > > > > > > ------------------------------ > > > 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. > >
