Attached powerShell script is very useful to get detail reports of all documents in a SharePoint Site Collection or site and sub sites. This script will list all document libraries which also system libraries(i.e. Master Page Gallery, List Template Gallery, etc.) and will list all documents in them.We have tested it on SharePoint 2016, 2013 and 2010 servers.

It contains a Function named Get-DocInventory which take single parameter i.e Site URL

 

PowerShell
Edit|Remove
Get-DocInventory "http://sp2013"

 

It will list the following properties of a document

Check below image which show the detail report.

You can easily sort data by library name, title or by size.

There are two ways two execute this script,

you can open script out put in grid view or can also export output in CSV format

Run below command to get output in grid view

 

PowerShell
Edit|Remove
Get-DocInventory "http://sp2013" | Out-GridView
 

Run below command to export output in CSV file.

 

 

PowerShell
Edit|Remove
Get-DocInventory "http://sp2013" | Export-Csv -NoTypeInformation -Path c:\csv\Documents_Detail_Report.csv