FileSystem Monitoring

Thu, 22 Aug 2013 13:59:05 GMT

Hi All,

We are attempting to build a FS Monitor application. The data would look as below:

A	2762001	8/2/2013 12:41:08 PM	39034	11:58:02 AM
A	5361	8/22/2013 10:36:26 AM	84	10:31:11 AM
A	6335	8/22/2013 10:36:12 AM	98	10:31:11 AM
A	14695	8/22/2013 10:36:20 AM	84	10:31:11 AM
A	17231	8/22/2013 10:36:06 AM	98	10:31:11 AM
A	5531	8/22/2013 11:23:36 AM	84	11:18:19 AM
A	6533	8/22/2013 11:23:22 AM	98	11:18:19 AM
A	14872	8/22/2013 11:23:30 AM	84	11:18:19 AM
A	17405	8/22/2013 11:23:10 AM	98	11:18:19 AM
B	80226267	8/5/2013 11:37:02 AM	199999	11:21:55 AM
C	141472	8/1/2013 12:19:38 PM	1045	11:21:55 AM
C	467	8/22/2013 10:36:56 AM	3	10:31:11 AM
C	919	8/22/2013 10:36:50 AM	3	10:31:11 AM
C	475	8/22/2013 11:24:06 AM	3	11:18:19 AM
C	927	8/22/2013 11:24:00 AM	3	11:18:19 AM
D	127	8/22/2013 10:37:26 AM	1	10:31:11 AM
D	357	8/22/2013 10:37:20 AM	1	10:31:11 AM
D	131	8/22/2013 11:24:36 AM	1	11:18:19 AM
D	361	8/22/2013 11:24:30 AM	1	11:18:19 AM
A	686	8/22/2013 11:19:48 AM	11	11:15:03 AM
A	1713	8/22/2013 11:20:02 AM	30	11:15:03 AM
A	1970	8/22/2013 11:19:44 AM	11	11:15:03 AM
A	5034	8/22/2013 11:19:56 AM	30	11:15:03 AM
D	164	8/22/2013 11:20:50 AM	2	11:15:03 AM
D	484	8/22/2013 11:20:46 AM	2	11:15:03 AM
A	566	8/22/2013 11:14:04 AM	11	11:09:34 AM
A	1403	8/22/2013 11:14:20 AM	30	11:09:34 AM
A	566	8/22/2013 11:26:26 AM	11	11:22:02 AM
A	1403	8/22/2013 11:26:42 AM	30	11:22:02 AM

I need to aggregate all the records for each 15 minute interval.by data source type. i.e., I need one record for each data source type for all records between 11:00 to 11:15, 11:15 to 11:30 and so on..

How can i achieve this in qlikview. Please provide your thoughts around this...

Regards,

Amar

Re: FileSystem Monitoring

Thu, 22 Aug 2013 14:00:42 GMT

The schema is :

1)Datasource

2)Filesize

3)DateTime

4)RecordCount

5) Time

topic FileSystem Monitoring in QlikView

FileSystem Monitoring

Re: FileSystem Monitoring