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: