Help on Customized Report with DQL

Hi team,

 

we want to build a csv report which can be formatted as below for a specific file type (example; txt files) :

Pathname | Total Size | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4

We have got the pathname | total size ok, but need some guidance on how we can filter the total size to buckets of every 3 months?

Below is the dql query which shows the pathname | total size, but we can't format the bucket size as a dql query. Any advice is appreciated.

Thanks,

CH

-----------------

FROM     path
GET     parent.absname,
device.name,
msu.name,
extension,
count(id) AS file_count,
sum(size) AS sum_file_size_bytes
IF type="file"
AND
extension IN ("txt")
AND
last_accessed >= datetime('2014/06/02 00:00', 'YYYY/MM/DD HH:mm')
AND
last_accessed <= datetime('2015/02/02 23:59', 'YYYY/MM/DD HH:mm')
GROUPBY device.name, msu.name, parent.absname,extension