https://community.dynatrace.com/t5/DQL/DQL-for-disks-with-wasted-space/m-p/284384#M2484 <P>try something like this...</P><LI-CODE lang="markup">timeseries t_disk=avg(dt.host.disk.used.percent), interval: 2h,by:{dt.entity.host, dt.entity.disk} | fieldsAdd Server=entityName(dt.entity.host) | fieldsAdd Disk=entityName(dt.entity.disk) | fieldsAdd `Used_Disk_Space_(%)`=arrayAvg(t_disk) | fieldsRemove timeframe,interval, dt.entity.host, t_disk | join [ timeseries disk.used_sum = avg(dt.host.disk.used), disk.avail_sum = avg(dt.host.disk.avail), by:{dt.entity.disk} | fieldsAdd total_disk = toLong((arrayAvg(disk.used_sum) + arrayAvg(disk.avail_sum)) / 1024 / 1024) | fieldsKeep total_disk, dt.entity.disk ], on:{dt.entity.disk} | fieldsAdd `Total_Disk_(GB)` = right.total_disk | fieldsRemove right.dt.entity.disk, right.total_disk | sort `Used_Disk_Space_(%)` desc | limit 10</LI-CODE> Wed, 20 Aug 2025 16:21:07 GMT jason_gs 2025-08-20T16:21:07Z https://community.dynatrace.com/t5/DQL/DQL-for-disks-with-wasted-space/m-p/284310#M2483 <P>Hello,</P> <P>could you help me with dql to generate a table with the following columns :&nbsp; host, disk, disk total size and disk usage% (or disk available) order by disk total size desc, top n records .</P> <P>Thx!</P> Mon, 01 Sep 2025 09:59:15 GMT https://community.dynatrace.com/t5/DQL/DQL-for-disks-with-wasted-space/m-p/284310#M2483 LouisCypher 2025-09-01T09:59:15Z https://community.dynatrace.com/t5/DQL/DQL-for-disks-with-wasted-space/m-p/284384#M2484 <P>try something like this...</P><LI-CODE lang="markup">timeseries t_disk=avg(dt.host.disk.used.percent), interval: 2h,by:{dt.entity.host, dt.entity.disk} | fieldsAdd Server=entityName(dt.entity.host) | fieldsAdd Disk=entityName(dt.entity.disk) | fieldsAdd `Used_Disk_Space_(%)`=arrayAvg(t_disk) | fieldsRemove timeframe,interval, dt.entity.host, t_disk | join [ timeseries disk.used_sum = avg(dt.host.disk.used), disk.avail_sum = avg(dt.host.disk.avail), by:{dt.entity.disk} | fieldsAdd total_disk = toLong((arrayAvg(disk.used_sum) + arrayAvg(disk.avail_sum)) / 1024 / 1024) | fieldsKeep total_disk, dt.entity.disk ], on:{dt.entity.disk} | fieldsAdd `Total_Disk_(GB)` = right.total_disk | fieldsRemove right.dt.entity.disk, right.total_disk | sort `Used_Disk_Space_(%)` desc | limit 10</LI-CODE> Wed, 20 Aug 2025 16:21:07 GMT https://community.dynatrace.com/t5/DQL/DQL-for-disks-with-wasted-space/m-p/284384#M2484 jason_gs 2025-08-20T16:21:07Z