0 Replies Latest reply: Nov 2, 2011 2:32 PM by rorival00 RSS

    New to QV. How do I build this table from txt?

      I'm a brand new user to QV (just finished the training).  I have never used a BI tool before and this is my first experience. 

      How do I build this table? 
      I received a daily log file from 20 systems installed in our company.  Each log has details on disk usage only.  They are all prod dev boxes. 
      This is the format of the file name ... ibm100.diskdata.Nov01-2011.  Each host has several disks and file systems.  My user wants to build a trend at the file system level to track disk usage.  This is the content of the files:

       

      sunsystem1.diskdata.oct2-2011

      filesystem                                   size          used          avail          capacity           diskmount

      /folder/filesystem/disk1                    100gb          48gb     52gb          49%               system/data

      /folder/filesystem/disk2                     72gb           55gb     17gb          49%               system/data

      /folder/filesystem/disk2                     72gb           55gb     17gb          49%               system/data

      --

      sunsystem1.diskdata.Oct3-2011

      (Same data except activity changes in the column files)

       

      Q. How do I capture this daily data in a QV table?

           How do I represent each filesystem per host in a table or chart?

       

      Thanks in adv