Home >Tips >Move files into SharePoint >Fileshare inventory kalmstrom.com site map icon Site map  

PowerShell Script for Folder Inventory Statistics

Move files into SharePoint 1

A SharePoint tutorial by Peter Kalmstrom

PowerShell iconPeter 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

  1. Make sure you have read permissions over the folders and also permission to see permissions.
  2. 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.
  3. Open the CSV files in Excel and split the data.
  4. Use standard Excel features to give a good presentation of the data.
Folder content Excel chart

You are welcome to download the PowerShell script shown in the demo: https://www.kalmstrom.com/Tips/Files/FilesInventory.zip.



Follow kalmstrom.com on LinkedInFacebook or Twitter!
back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved