Cacher is the code snippet organizer for pro developers

# ----------------------------------------------
# Author: Romain Blanchard
# Date: 26.06.2012
# Description: Get SharePoint Database information and format the output.
# ----------------------------------------------

cls
write-host ""
write-host "---------- Sharepoint Database status ----------" -ForegroundColor Yellow
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null
$SMOserver = New-Object ('Microsoft.SqlServer.Management.Smo.Server') -argumentlist rexpor-sql01-pprd
Get-SPContentDatabase | Select-Object Name, WebApplication, Status, @{Name="Size";Expression={"{0:N1}MB" -f($_.DiskSizeRequired/1mb)}}, @{Name="LogSize";Expression={"{0:N1}MB" -f(($SMOserver.Databases[$_.Name].logfiles | measure-object -property Size -sum).Sum/1024)}} |
Format-Table