AIIM Open Forum

Topic: Tool for File Share Analysis

1.  Tool for File Share Analysis

Posted 9 days ago
Hello all, we are searching for the right tool to do an pre-migration analysis of our file shares that tells us the following:
  • Metadata Requirements:
    • File Type [Type]
    • File Name [Filename]
    • File Path [Path]
    • Created by [Creators] or [Owner]
    • Created Date [Date created]
    • Modified by [Authors]
    • Modified Date [Date last saved]
    • Last Accessed Date [Date accessed]
    • Last Accessed by
    • File Type [File extension]
    • File Size [Size]
  • Output that can be filtered by:
    • Last Accessed date
    • Last Modified date
    • Identified duplicate documents
ShareGate has some of these functions, but not all. We've also looked at AvePont, but the price is a little prohibitive. Can anyone recommend anything? Thank you!

Joanna Crump, MS, MLIS
Corporate Librarian
FamilyCare Health

2.  RE: Tool for File Share Analysis

Posted 8 days ago
Hi Joanna,

I needed the same thing just this last year for a client of mine; migrating 6 million files from file shares to SharePoint.  They didn't want to purchase any 3rd party tools for a one-shot migration, so I wrote PowerShell scripts to do the entire migration.  In general there is a script that will scan a file share and write a CSV file as output.  That file can then be opened in Excel and manipulated.  I then wrote scripts to read that CSV file and perform the actual migration.

if you choose to go with a tool like PowerShell, you may have to run multiple reports as I found once you reach about 80,000 rows in Excel, it becomes painfully slow to work with.

Robert Mixon
Senior SharePoint Architect

3.  RE: Tool for File Share Analysis

Posted 7 days ago

I have used TreeSize both free version and paid, it is inexpensive and very usable. Gives you a good overview and statistics (graphs) on sizes, distribution, frequency of use with all the necessary metadata on files.

best regards, Sigurjón

Sigurjón Hákonarson

4.  RE: Tool for File Share Analysis

Posted 8 days ago
Metalogix and TreeSize.  I've been deeply involved in a major project using Metalogix and was quite impressed.  TreeSize is a recent recommendation and much more cost effective.  I believe it's free. Hope that helps!

Cheryl Banke, CRM, MLIS
Belvedere Consulting, LLC

5.  RE: Tool for File Share Analysis

Posted 7 days ago
I have used TreeSize Pro on several Team Site migrations from file shares to SharePoint.
Hope this helps...

Mike Justice
Documentation Specialist
Estes-Express Lines

6.  RE: Tool for File Share Analysis

Posted 8 days ago
Nuix can help you with that. Reach out to me at Brian.tuemmler@...


Brian Tuemmler
IG Product Manager

7.  RE: Tool for File Share Analysis

Posted 8 days ago
Take a look at Record Lion, I think it will meet your needs.

Susan Gleason CRM, CIP
System Specialist
Pitney Bowes Inc.

8.  RE: Tool for File Share Analysis

Posted 8 days ago
File Facets is a great tool for this and other aspects of migration.


Brett Walters
Director of Application Solutions

12560 Reed Road ◦ Suite 200 ◦ Sugar Land, Texas 77478
o 888.267.7827 ◦ m 713.257.0647

9.  RE: Tool for File Share Analysis

Posted 8 days ago

AvePoint is often considered the 'cadillac' option for sure.  However, if you don't have some sort of ongoing use case for it it IS fairly challenging to justify the cost.

Metalogix is also a very good choice as Cheryl said.  I would also support Susan's recommendation of Record Lion (which was JUST acquired by Gimmal).  Finally, you should also look seriously at Concept Searching

Hope that helps.

Lorne Rogers (Seeking new role!)
Aria Consulting & Implementers Ltd.

10.  RE: Tool for File Share Analysis

Posted 8 days ago
Edited by William Benson 8 days ago
I would recommend looking at Filefacets.  They have a great toll for analytics that will identify the items you listed. It will also separate the ROT (redundant, obsolete and trivial). But it goes beyond just identifying,   It will build a taxonomy, by applying meta data then allows you to migrate with a push of a button.

William Benson
Director of Business Development
Gordon Flesch Company, Inc.

11.  RE: Tool for File Share Analysis

Posted 4 days ago

i have completed these type of projects and recommend one of these three Filefacet, Metalogix and TreeSize. That being said, Treesize is the least inexpensive but is a "particular" type of product. Whichever you choose, you will have to be efficient, effective and accurate in tracking by breaking down in phases. TreeSize allows you to separate per item (ie: duplicates, file other count, empty folders? Etc) but won't allow you a full report of the entire database, only a total count. I would love to offer my assistance should you need it. I just completed one of these exact projects (content management - clean up and migration to SP on Office 365) and have a lot of best practices to share. 

Take care,

Aura Cruz
Sr. Consultant, Governance, BPM, RIM
Eberle Media & Consulting

12.  RE: Tool for File Share Analysis

Posted 3 days ago
The Metropolitan Water District of Southern California has issued RFP PL-1154 for services and software to optimize the file storage on their shared drives and develop a Metropolitan-wide taxonomy.

Michael Tracey
IT Program Manager
Metropolitan Water District of Southern California

13.  RE: Tool for File Share Analysis

Posted 4 days ago

Depending on your ultimate objective this can be approached in many ways.  We have used Robocopy which is embedded in Windows operating systems and then had our IT operating systems folk run a command which tells us the size and volume, number of files on particular drives.  We then run a command to split files on the drives, based on Last Accessed Date (must be touched in the last 3 years) into two sections and have users focus on the last 3 years for initial migration.


We have used Duplicate File Finder (free download) to find and delete duplicates as well as have users clean up on their own:


We then use ShareGate to migrate documents.


After implementation, drives are set to read only and an assessment is made of what is left and of true value to migrate (based on business value, records retention etc).   This backlog is then done over a period of 1 year.


Rachel Larson, ermm, CIP

Analyst III, EDRM

Governance, Risk and Compliance

Business Technology Services

Cameco Corporation

Corporate Office

2121 11th Street West

Saskatoon, SK   S7M 1J3

Tel:  306-956-6596

Email:  Rachel_larson@...


*please consider the environment before printing this email 


This email and any files transmitted with it are personal and confidential, and are solely for the use of the individual or entity addressed. Therefore, if you are not the intended recipient, please delete this email and any files transmitted with it (without making any copies) and advise the author immediately.

14.  RE: Tool for File Share Analysis

Posted 4 days ago
Hi Joanna,

some useful feedback here already with some excellent suggestions for commercial software. Since no one has mentioned it yet, I'd also look at DROID - a free tool from the National Archives (

There are easier and faster tools to use, but hey it's free and outputs the kind of information you need including duplicate detection so worth consideration.


Scott Johnson
Senior ECM Consultant

15.  RE: Tool for File Share Analysis

Posted 2 days ago
Hi Joanna

I asked our SharePoint Consultant, Pramit John for suggestions. He said:  'We use AvePoint over here and it’s been pretty good. I think even Quest ( ) has tools to do the file share migration. For analysis I would definitely break the source into different logical sections. Use PowerShell to do the analysis and export the data into a database table and use a BI tool to do the analysis. As Robert mentioned, even I have seen this issue in Excel where it crashes due to the huge volume of records, typically in millions, or it trims the content'.

Belinda Finocchiaro
Records Management Officer
NSW Treasury Corporation (TCorp)
Sydney, Australia

16.  RE: Tool for File Share Analysis

Posted yesterday
Hi Joanna,
You've a couple of different mainstream options from the big software vendors, we have a preference to use IBM StoredIQ as you can take it on a SaaS license - determine the length of time (months) for the project and purchase the license for that duration only. It covers all the requirements you've mentioned whilst not being overly expensive.

Happy to help if you need a demo etc.


James Donnelly
Senior Director
Alvarez & Marsal Disputes and Investigations, LLP

17.  RE: Tool for File Share Analysis

Posted 13 hours ago
We use Treesize Pro, it is not free but is inexpensive.  However, I recommend that you plan this a project, so that you do it Iogical chunks - we are doing it by team, and depending on who is going to be doing the file cleansing (i.e. you or users), you can format the resulting report in a way that it can be easily used.  We do an initial report then a further analysis to look at: file type (what cannot be migrated to SharePoint); file age (for retention rule application); file size (for overlarge files, or empty files) and duplication.  Running the initial report can take time, so we tend to do it overnight.

We have found that getting teams to identify exactly where their data is, and give us accurate file paths, has sometimes needed to be done more than once!

Hope this helps

Madi McAllister
Information Governance & Records Management Office

18.  RE: Tool for File Share Analysis

Posted 6 hours ago

Please Check out Adlib Software, Adlib is helping to address a gap in the market with a unique file analytics approach, which leverages the creation of standardized high-definition content and classification with built-in repeatable intelligence. Industry adoption of file analysis technologies like Adlib Elevate is growing and predicted to jump from 10% to 50% by 2020.

Steve Studer
Senior Technical Strategist
Adlib Software