How to see all site collections in a specific content DB

SPAdmin picture SPAdmin · Dec 22, 2011 · Viewed 63.5k times · Source

How can I see all site collections associated in a specific Content db in SharePoint 2010?

Any advice or suggestion is highly appreciated.

Answer

SPAdmin picture SPAdmin · Jan 5, 2012
Get-SPSite -Limit All  -ContentDatabase contentdbname | select url, @{label="Size";Expression={$_.usage.storage}}