I've done something like that in PowerShell with the object model in v3.0 and I'm assuming this could be done the same way for v2.0. The script below is just recursively spinning through and outputting the SPWeb Title...but could be extended to then spin through every list and aggregate the file attachments sizes and report on them.
$webappUrl = "http://sitecollectionurl/";; Clear-Host $12HivesDir = "${env:CommonProgramFiles}\Microsoft Shared\web server extensions\12\" [System.Reflection.Assembly]::LoadFrom("$12HivesDir\ISAPI\Microsoft.SharePoint.dll") function get-spweb ([String]$webUrl=$(throw 'Parameter -webUrl is missing!')) { $site = New-Object -TypeName "Microsoft.SharePoint.SPSite" -ArgumentList "$webUrl"; return $site.OpenWeb(); } function get-spwebInfo ($web) { Write-Host $web.Title Write-Host $web.Url if ($web.Webs.Count -ne 0) { Write-Host "=======================================" Write-Host "Sub webs of " $web.Title Write-Host "=======================================" foreach ($subweb in $web.Webs) { get-spwebInfo($subweb); $subweb.Dispose(); } Write-Host "=======================================" } } $devWeb = get-spweb $webappUrl get-spwebInfo($devWeb); $devWeb.Dispose(); From: [email protected] [mailto:[email protected]] On Behalf Of Darren Neimke Sent: Wednesday, 10 June 2009 8:28 AM To: [email protected] Subject: WSS 2.0 Content Reporting Hi all, does anybody on this list have (or know of) a favorite tool for producing a report about the number of documents and the total allocated content storage size for a given SharePoint (WSS 2.0) site? Ideally, I'd like to point it at a number of sites (or at an individual site collection) and see, at a glance, information such as: Site Name Library Name Items Total Size ------------------------------------------------------- Site A LibA 42 32MB Site A LibB 16 10MB Site B LibA 38 8MB Site B LibB 13 16MB Kind Regards, Darren Neimke [email protected]<mailto:[email protected]> ________________________________ Windows Live(tm) SkyDrive(tm): Get 25 GB of free online storage. Get it on your BlackBerry or iPhone.<http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_SD_25GB_062009> ________________________________ Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists -------------------------------------------------------------------------------- Support procedure: http://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists
