I have upload a Powershell script in Technet Gallery which will be 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 both SharePoint 2013 and SharePoint 2010 servers. (Click here to download the script file)
It contains a Function named Get-DocInventory which take single parameter i.e Site URL
Get-DocInventory "http://sp2013"
It will list the following properties of a document
- Site URL
- Web URL
- Library Name
- ID
- Title
- File URL
- File Size
- File Size (MB)
- Modified Date
- Modified By
- Created Date
- Created By
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:
Get-DocInventory "http://sp2013" | Out-GridView
Run below command to export output in CSV file:
Get-DocInventory "http://sp2013" | Export-Csv -NoTypeInformation -Path c:\csv\Documents_Detail_Report.csv
Adnan is six time Microsoft MVP (Since 2015) with over 16 years of extensive experience with major expertise on SharePoint, SharePoint based development, Microsoft 365, Microsoft Teams, .Net Platform and Microsoft BI. He is currently working Sr Microsoft Consultant at Olive + Goose. He is MCT Regional Lead for Pakistan Chapter since 2012. He is working on SharePoint for past 12 years and worked on different intranet/intranet solutions for private & govt. sector majorly in United states and Gulf region and have experience of working with multiple Fortune 500 companies. He is a trainer, technology evangelist and also speaks in community forums.
Leave a Reply
You must be logged in to post a comment.
2 replies on “Get detail report of all Documents in SharePoint site using Powershell”
Hi Adnan,
I was looking of a way to report on site content in SharePoint 2010 and came to this post. Seems exactly what I need – thank you for sharing that.
Unfortunately the link to the script above brings MS Technet (now MS Learn) galley, but not your script… 🙁
Do you have the script published somewhere else or any chance to email it to me, please?
Thank you in advance.
Best,
RS
TechNet was a great repository, I have uploaded couple of old scripts on Github. I am not sure but you can find similar scripts.
https://github.com/Adnanamin/SharePoint-PowerShell