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

CSV

• Export SharePoint Search Crawl log to CSV File.

Powershell

• Delete Quick Links using Powershell
• delete/Add Top Navigation Links using Powershell
• Get CheckedOut Files from SharePoint 2013 and MOSS2007
• PowerShell::Get Content Database Size in SharePoint
• 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
• Check Whether PowerShell Process is 32-bit or 64-bit?
• How to send Email by using Powershell in SharePoint
• Create Site Column Using Power Shell and Server Object Model
• Admin SVC must be running in order to create deployment timer job
• WSP Deployments in SharePoint using Powershell
• Create Site Collection by using Power Shell
• Create Web Application by using Powershell
• Backup Site Collection/Sub site/List(Library) in Share Point
• Get Site Collection Details using STSADM
• WSP Backup from Central Administration in Share Point
• Deactivate/Delete Site Template through Power shell