Total Size of Preservation Hold Libraries

Amrah_Chughtai This may be a bit late but here's something I wrote that should point you in the correct direction.

The below PowerShell script requires modules for SharePoint Online Powershell and SharePoint PnP to be available on the machine. 

Known issues:

• The script does not process sub-sites, this can probably be easily fixed.
• The "Measure-PNPList" cmdlet fails if the number of items in the preservation hold library exceeds the list view limit. The limit can be changed on the target sites, not sure if it can be done using PowerShell.

Hope this helps and perhaps someone else will improve and share a new version of the script 🙂

$Out = @()

$sites = Get-SPOSite -Limit ALL
$Sites = $Sites | Sort-Object StorageUsageCurrent -Descending

foreach ($Site in $Sites){

Connect-PnPOnline -Url $site.Url -Interactive

$SiteSize = $Site.StorageUsageCurrent
$PHLib = Get-PnPList -Identity PreservationHoldLibrary

if($PHLib){
$PHSize = ($PHLib | Measure-PnPList).TotalFileSize
$PHSize = $PHSize / 1024 / 1024
}
else {continue}

if(!$PHSize){continue}

$item = New-Object PSObject
$item | Add-Member -type NoteProperty -Name 'Url' -Value $site.Url
$item | Add-Member -type NoteProperty -Name 'SiteSizeMB' -Value $SiteSize
$item | Add-Member -type NoteProperty -Name 'PreservationSizeMB' -Value ([math]::Round($PHSize))
$item | Add-Member -type NoteProperty -Name 'PreservationPercentage' -Value ([math]::Round((($PHSize/$SiteSize)*100)))

$item

$out +=$item
}