Reporting on SharePoint MySite distribution by Content Database

76

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 " " 
}

Share this entry

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents

Categories

Categories