![]() ![]() That it allowed me to analyse in a much efficient way how files were stored by the users. ![]() I found the filescan I was developping with a SQL DB was quite well suited for a OLAP Cube with parent-child dimension (which never worked on essbase.) it was the time I was playing with VB6 and implementing essbase servers so I was begining to understand what OLAP meant, and looked for MS solution. Why remake a treesize when there are other treesize applications out there?įirst this project started about 6 years ago when I was confronted with a simple problem : there are too many files on our company file servers! what can we do ? (the scan is multithread and run on the 22 share simultaneously) Background The scan run in a command line on the server hosting the database for convenience purpose and take around 25-26 hours to run. There are 22 network share scanned for a grand total of 1.4 Milions folders and 15 Million files. Real life case, I'm using this soft to scan weekly the file servers where I'm working. Excel pivot-table connected to the is a greatway to access some of this data. This data once stored is used to calculate a simple MS OLAP application (MS Analysis Services 2008) that will consolidate file number and filesize on multiple dimension, recreating the folder tree and then can be used in many way.
0 Comments
Leave a Reply. |