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

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Chin there is not a mechanism

Chin there is not a mechanism to use the bucket filters on the DQL created reports in any currently shipping version. You could create the report and then filter it further by querying the generated database with SQL statements or use the canned report for Data Aging report bucket size under Data Lifecycle Reports section in the Reports tab of the Symantec DataInsight Console.

 

Rod

View solution in original post

1 Reply
Highlighted
Accepted Solution!

Chin there is not a mechanism

Chin there is not a mechanism to use the bucket filters on the DQL created reports in any currently shipping version. You could create the report and then filter it further by querying the generated database with SQL statements or use the canned report for Data Aging report bucket size under Data Lifecycle Reports section in the Reports tab of the Symantec DataInsight Console.

 

Rod

View solution in original post