Generate usage statistics at specified storage location and output a detailed CSV file containing file metadata.
Get help:
> StorageUsageReporter.exe --help
StorageUsageReporter 1.0.0.0
Copyright Scott Lerch 2014
-p, --paths Required. Paths to perform recursive analysis.
-o, --output (Default: output.csv) Output file to store analysis.
-s, --sanitize (Default: False) Hash identifiable names.
-r, --rollup (Default: False) Rollup metadata to directory level.
-c, --recursiveRollup (Default: False) Rollup metadata to directory level
recursively.
--help Display this help screen.
Local drive:
> StorageUsageReporter.exe -p C:\
Starting at 2/6/2014 6:54:26 PM...
Completed in 00:00:50.9157842!
Locations analyzed: C:\
Detailed output: output.csv
Items Count : 493953
Total Size : 140.6 GB
Average Size : 298.4 KB
Median Size : 5.9 KB
Local drive with rollup:
> StorageUsageReporter.exe -p C:\ -r
Starting at 2/6/2014 6:55:52 PM...
Completed in 00:01:09.8247372!
Locations analyzed: C:\
Detailed output: output.csv
Items Count : 64386
Total Size : 140.5 GB
Average Size : 2.2 MB
Median Size : 26.4 KB
File share:
> StorageUsageReporter.exe -path \\filesrv1\Documents
Starting at 2/6/2014 6:58:30 PM...
Completed in 00:00:10.8205564!
Locations analyzed: \\filesrv1\Documents
Detailed output: output.csv
Items Count : 71772
Total Size : 8.4 GB
Average Size : 122.9 KB
Median Size : 4.3 KB
File shares with sanitized output:
> StorageUsageReporter.exe -p \\filesrv1\Documents \\filesrv1\Pictures -s
Starting at 2/6/2014 6:59:10 PM...
Completed in 00:00:10.9154797!
Locations analyzed: \\filesrv1\Documents;\\filesrv1\Pictures
Detailed output: output.csv
Items Count : 76841
Total Size : 18.5 GB
Average Size : 252.6 KB
Median Size : 4.8 KB
Sample output.csv file with sanitized names:
DirectoryPath,FileName,FileExtension,FileSize,CreationTimeUtc,LastAccessTimeUtc,LastWriteTimeUtc
830A41F4,830DDBDE,gitconfig,57,2013-08-25T05:37:24.146531Z,2013-08-25T05:37:24.1645425Z,2013-08-25T05:37:24.1655432Z
830A41F4,F7D86809,octave_hist,588,2014-01-23T05:07:39.08688Z,2014-01-23T05:07:39.08688Z,2014-01-23T05:07:39.08688Z
830A41F4,ABA88AB9,mdf,3211264,2013-11-16T04:14:49.9477779Z,2013-11-16T04:14:49.9477779Z,2014-01-19T00:43:17.0684181Z
830A41F4,E87C7477,ldf,802816,2013-11-16T04:14:49.9661037Z,2013-11-16T04:14:49.9661037Z,2014-01-19T00:43:17.069427Z
830A41F4,43492A74,DAT,12845056,2013-10-21T02:29:10.6986923Z,2014-01-19T00:43:40.7219919Z,2014-01-19T00:43:40.7219919Z
830A41F4,E0068FBB,LOG1,12201984,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.7768018Z
830A41F4,E0068FBE,LOG2,4657152,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.7768018Z
830A41F4,415CC0FD,blf,65536,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.8705827Z
830A41F4,AE594576,regtrans-ms,524288,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.8705827Z
830A41F4,E6C98C51,regtrans-ms,524288,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.7768018Z,2013-10-21T02:29:10.8705827Z
830A41F4,422E1686,blf,65536,2013-10-25T15:55:40.9964471Z,2013-10-25T15:55:40.9964471Z,2013-11-02T05:53:05.8839978Z
830A41F4,B4B49EED,regtrans-ms,524288,2013-10-25T15:55:40.9964471Z,2013-10-25T15:55:40.9964471Z,2013-11-02T05:53:05.8839978Z
830A41F4,949980C8,regtrans-ms,524288,2013-10-25T15:55:41.0120719Z,2013-10-25T15:55:41.0120719Z,2013-11-02T05:53:05.8839978Z
830A41F4,E8E6E2CB,ini,20,2013-10-23T16:01:17.6752736Z,2013-10-23T16:01:17.6752736Z,2013-10-23T16:01:17.6752736Z
8C8B45E0,3C3CB9F1,zip,79304187,2013-08-25T23:26:54.6915246Z,2013-08-25T23:26:54.6915246Z,2008-11-23T00:39:29Z
8C8B45E0,57987C48,m4v,260902030,2013-08-25T23:28:03.9472248Z,2013-08-25T23:28:03.9472248Z,2011-02-21T02:55:08Z
8C8B45E0,FFE0EF6A,ini,504,2013-08-25T03:49:49.9593375Z,2013-08-25T03:49:49.9593375Z,2013-11-18T03:37:37.1705881Z
- When using recursive roll-up the statistics are nonsensical since it adds up the already recursively added up file sizes
- Even if running as Aministrator or NT AUTHORITY/SYSTEM some directories may not be included due to unauthorized access exceptions
AlphaFS - Peter Palotas:
http:https://alphafs.codeplex.com/
Command Line Parser - Giacomo Stelluti Scala:
https://github.com/gsscoder/commandline
ILRepack - Francois Valdy:
https://github.com/gluck/il-repack
PowerCollection - Wintellect
http:https://powercollections.codeplex.com/