This script will help you to retrieve all the document libraries in Site Collection and will give details about the library using simple method.

Steps
  1. Open your SharePoint Management Shell.
  2. Copy the below code.
  3. Run this one.
Code

Load the below required libraries before we execute the code.
  1. [System.Reflection.Assembly]::Load("Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
  2. [System.Reflection.Assembly]::Load("Microsoft.SharePoint.Portal, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
  3. [System.Reflection.Assembly]::Load("Microsoft.SharePoint.Publishing, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
  4. [System.Reflection.Assembly]::Load("System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
  1. function Get-DocReport([string]$siteUrl) {
  2. $SPsite = New-Object Microsoft.SharePoint.SPSite $siteUrl
  3. foreach ($web in $SPsite.AllWebs) {
  4. foreach ($list in $web.Lists) {
  5. if ($list.BaseType -eq "DocumentLibrary") {
  6. continue
  7. }
  9. foreach ($item in $list.Items) {
  10. $data = @{
  11. "Site" = $site.Url
  12. "Web" = $web.Url
  13. "list" = $list.Title
  14. "Item ID" = $item.ID
  15. "Item Title" = $item.Title
  16. "Created By" = $item["Author"]
  17. "Modified By" = $item["Editor"]
  18. "File Size (MB)" = $item.File.Length/1MB
  19. }
  20. New-Object PSObject -Property $data
  21. }
  22. }
  23. $web.Dispose();
  24. }
  25. $site.Dispose()
  26. }
  29. Get-DocReport "http://gowthamr.sharepoint.com" | Export-Csv -NoTypeInformation -Path "D:\OuputFolder\DetailReport.csv"
That's it. We are now good to go.