Curious how much data is in your SharePoint on premises site collection recycle bin? SharePoint does not provide a way to determine this. Fortunately, PowerShell can accomplish this with relative ease. The following PowerShell script will process site collection first and second stage recycle bins and report back on storage space used. Remember to modify the $SiteColl variable and point it to a valid site collection first!
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
# Title: Get-RecycleBinSize.ps1 # Version: 1.0, 13 APR 2020 # Author: James Sanders # Purpose: Calculate and display size of site collection recycle bin (first and second stage) # Add the PowerShell Snap-In Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue # Site Collection to query $SiteColl = "http://mybigfatsharepointsite.com/demo" #Get the site collection Try { $site = Get-SPSite $SiteColl -ErrorAction Stop } Catch { Write-Host Write-Host -ForegroundColor Red "- Unable to open site collection $SiteColl" Write-Host Break } # FIRST STAGE RECYCLE BIN # Create SPRecycleBinQuery object to query the first stage recycle bin $SPRecycleBinQuery = New-Object -TypeName Microsoft.SharePoint.SPRecycleBinQuery $SPRecycleBinQuery.ItemState = [Microsoft.SharePoint.SPRecycleBinItemState]::FirstStageRecycleBin $SPRecycleBinQuery.RowLimit = [int]::MaxValue-1 # Get the sum of 'Size' property of all recycle bin items $RecycleBinSize = $site.GetRecycleBinItems($SPRecycleBinQuery) | Measure-Object -Property Size -Sum | Select-Object -ExpandProperty Sum # Calculate the value in MB $size = ([System.Math]::Round(($RecycleBinSize/1Mb),2)) write-host "First Stage Recycle Bin Size (MB):" $size # SECOND STAGE RECYCLE BIN # Create SPRecycleBinQuery object to query the second stage recycle bin $SPRecycleBinQuery=new-object Microsoft.SharePoint.SPRecycleBinQuery $SPRecycleBinQuery.ItemState = [Microsoft.SharePoint.SPRecycleBinItemState]::SecondStageRecycleBin $SPRecycleBinQuery.RowLimit = 2000 $size=0 DO { $SPRecycleBinItemCollection = $site.GetRecycleBinItems($SPRecycleBinQuery) $SPRecycleBinQuery.ItemCollectionPosition = $SPRecycleBinItemCollection.ItemCollectionPosition For($i=$SPRecycleBinItemCollection.Count-1; $i -GE 0; $i--) { $Size += $SPRecycleBinItemCollection[$i].Size } } While ($SPRecycleBinQuery.ItemCollectionPosition -Ne $Null) $size = ([System.Math]::Round(($size/1Mb),2)) Write-Host "Second Stage Recycle Bin Size (MB)" $size |
