Measure-MediaLibrarySize.ps1

This SPE script accurately measures overall media library size based on "Size" media field

# Define the folder path
$folderPath = "master:/sitecore/media library"

# Get all child media items recursively
$mediaItems = Get-ChildItem -Path $folderPath -Recurse -Language * -ErrorAction SilentlyContinue

# Calculate total size (in bytes) using the "Size" field
$totalSizeInBytes = 0

foreach ($item in $mediaItems) {
    # Directly read the "Size" field (which should store bytes as an integer)
    $sizeValue = [int]$item["Size"]
    if ($sizeValue -gt 0) {
        $totalSizeInBytes += $sizeValue
    }
}

# Convert to megabytes
$totalSizeInMB = [math]::Round($totalSizeInBytes / 1MB, 2)

Write-Host "Total size of $folderPath is $totalSizeInMB MB"

TODO: verify if does assess SXA variants, and if it does not - add this desired functionality