topic Re: Using QlikView to Solve my File System Nightmare in QlikView

Using QlikView to Solve my File System Nightmare

Thu, 19 Mar 2015 14:37:14 GMT

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

Re: Using QlikView to Solve my File System Nightmare

Anonymous — Thu, 19 Mar 2015 15:15:39 GMT

don't user QV for rhat task...

Re: Using QlikView to Solve my File System Nightmare

Anonymous — Thu, 19 Mar 2015 15:20:50 GMT

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.

Re: Using QlikView to Solve my File System Nightmare

Anonymous — Thu, 19 Mar 2015 15:49:46 GMT

use dir /b/s