cancel
Showing results for 
Search instead for 
Did you mean: 

Help on Customized Report with DQL

L33CH
Not applicable
Partner Employee Accredited

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 ACCEPTED SOLUTION

Accepted Solutions

Rod_p1
Level 6
Employee Accredited Certified

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 1

Rod_p1
Level 6
Employee Accredited Certified

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