之前一篇文章《两张图看清SharePoint 2013 Farm 逻辑体系结构》谈到Web Application,Content Database,Site Collection的关系。有了这个逻辑结构图之后,这篇文章将使用PowerShell,来更加直观的展现SharePoint WebApplication的体系结构。
Add-PSSnapin Microsoft.SharePoint.PowerShell
#Get-SPWebApplication |Get-Member#
Get-SPWebApplication | %{
Write-Host "`n -$($_.Url)";
foreach($cd in $_.ContentDatabases){
Write-Host "$($cd.Name)"
}
}
Add-PSSnapin Microsoft.SharePoint.PowerShell
Get-SPWebApplication | %{Write-Output "`n -$($_.Url)";foreach($cd in $_.ContentDatabases){
$ContentDatabaseSize = [Math]::Round(($cd.disksizerequired/1GB),2)
Write-Output "ContentName:$($cd.Name) `n Size:$($ContentDatabaseSize)G"
}}
Add-PSSnapin Microsoft.SharePoint.PowerShell
#Get-SPContentDatabase |Get-Member#
Get-SPContentDatabase | %{Write-Output "`n -$($_.Name)";foreach($site in $_.Sites){Write-Output "$($site.Url)"}} >>c:\xx2.txt
Add-PSSnapin Microsoft.SharePoint.PowerShell
Get-SPWebApplication |%{Write-Output "`n -$($_.Url)";$_.Sites | select url, @{label="Size in MB";Expression={[Math]::Round($_.usage.storage/1MB,2)}}|Sort-Object -Descending -Property "Size in MB"}>>c:\tt.txt