Reporting on SharePoint MySite distribution by Content Database

Wishv Prajapati

May 21, 2013

All Post

Reporting on MySite Content Databases

Knowing how sites are distributed among Content Databases is key, such as knowing which Content Database to restore for a given user.

Wouldn’t it be nice to see the breakdown of MySites, which belong to a given Content Database, and the total size of each Content Database? Here’s a script that generates this useful report:

$DBs = Get-SPWebApplication http://MySites | Get-SPContentDatabase
foreach ($db in $DBs)
{
 Write-Host -ForegroundColor DarkBlue "DB Name: $($db.Name)"
 $siz="{0:N3}" -f ($db.disksizerequired/1GB)
 write-host -ForegroundColor DarkBlue "DB Size: $($siz) GB"
 Write-Host "========"
 $db | Get-SPSite -Limit all
 Write-Host " "
}