Using QlikView to Solve my File System Nightmare

[#1]

All Qlikview experts -

I have a very common problem in my organization, my file system storage is completely out of control.  I have several hundered users, multiple business units and no effective control over file storage.  Security is not the problem, just storage consumption.

I know that QlikView would be a great visualization tool to help me identify where my greatest consumers of space are located and what types of files they are storeing, but frankly, I have no idea how to get started.  Does anyone have any experience using QV as a visualization tool for managing File System Storage that they would be willing to share?

Thank you in advance.

Bob Oblinsky

[Anonymous]

don't user QV for rhat task...

[Anonymous]

Robert

If it is just a one off then you could try something like this at the command line from your file storage root:

    dir /s /q /4 >> dirlist.txt                    WARNING:  If loads of files, then it will take a long to run.

Then load the resultant text file dirlist.txt into QlikView.  It will need some jiggery pokery in the load script to format it suitably.

[Anonymous]

use dir /b/s