Get Site Collections specific to a Content Database and Export to CSV

Hi All,

In a following post , we will see about a  Power Shell Script which is used to get Site Collections from Specific Content Database and generate a CSV Report .

Add-PSSnapin Microsoft.SharePoint.PowerShell

Get-SPSite -Limit All  -ContentDatabase WSS_Content_2015 | select url, @{label="Size";Expression={"{0:N2} MB" -f ($_.usage.storage/1000000)}} | Export-Csv D:\2015_db_sitecoll.csv 

In the above  example, WSS_Content_2015 is my content database and I am storing the report at D Drive with the name "2015_db_sitecoll.csv"

Thanks.

Related Post