5/27/2023 0 Comments Treesize server 2008it 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. ACLs (on folder only) and Rights inheritance.datetime info (creation, access, change).This article will present a tool coded in C# that will scan folders (UNC, local drive/path) and store data in a SQL Database the following informations : I decided to write this article after days of coding and finding resources and information on this site, so here it is, a tool I'm using almost everyday in my system admin life.
0 Comments
Leave a Reply. |