PowerShell Script for Folder Inventory Statistics
Move files into SharePoint 1
A SharePoint tutorial by Peter Kalmstrom
Kalmstrom, CEO of kalmstrom.com Business Solutions and Microsoft
certified SharePoint specialist, has in an assignment prepared
a move of millions of Office files into SharePoint.
In a series of Tips articles Peter will describe the whole
process of moving a huge amount of files into SharePoint.
The first step in the process of moving files was to discuss
with the client if some files should be deleted or not moved.
To give a visual overview over the contents of the folders,
Peter created a PowerShell script that listed the files
in CSV files. He then opened the CSV files in Excel, created
some charts that visualized the contents and showed them
to the managers.
Steps to visualize folder contents statistics in Excel
- Make sure you have read permissions over the folders
and also permission to see permissions.
- Run a PowerShell script that lists all folder contents
in CSV files. In the demo below Peter explains how his
script works, so that you can modify it to your needs.
- Open the CSV files in Excel and split the data.
- Use standard Excel features to give a good presentation
of the data.
You are welcome to download the PowerShell script shown
in the demo: