PowerShell::Get Content Database Size in SharePoint

Hi All,

In a following post we will see about a PowerShell Script which is used to get the Content Database Size in GB.

Code Snippet:

if(!(Get-PSSnapin Microsoft.SharePoint.PowerShell -ea 0))

{

Add-PSSnapin Microsoft.SharePoint.PowerShell

}

Get-SPSite -Limit All  -ContentDatabase WSS_Content_1212 | select url, @{label="Size";Expression={"{0:N2} GB" -f (($_.usage.storage/1000000)/1000)}}

Thanks.

Related Post

Migration

• Get CheckedOut Files from SharePoint 2013 and MOSS2007
• PowerShell :: Delete All List Items
• Powershell :: Apply Master Page to all sub sites under site collection
• Remove-SPSite 0x80070003 - Forcely delete Site Collection that cannot be deleted
• Migrate Multiple site(sub sites) using MetaLogix and change the Template in Target
• Issue:The date file "C:\ProgramData\Metalogix\EnvironmentSettings.xml" contains invalid data.Values in that file reset to defaults

ContentDatabase