https://community.dynatrace.com/t5/DQL/listing-the-most-consuming-processes-in-terms-of-Network-CPU/m-p/281337#M2289 <P>Hey Peter,</P><P>I spent some time on this and got as close as I could. It seems like not many have tried a query like this before. I couldn’t sort all fields due to inconsistent values, so I stuck with sorting by<SPAN>&nbsp;</SPAN>cpu_usage.</P><P>Hope this helps!</P><P><BR /><BR /></P><LI-CODE lang="javascript">timeseries avg(dt.process.cpu.usage), by: { dt.entity.process_group_instance } | fieldsAdd dt.entity.process_group_instance.name = entityName(dt.entity.process_group_instance) | fieldsAdd cpu_usage = arrayAvg(`avg(dt.process.cpu.usage)`) | lookup [ timeseries values=avg(dt.process.io.bytes_total), by: { dt.entity.process_group_instance } | fieldsAdd io_usage = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{io_usage}, executionOrder:leftFirst | lookup [ timeseries values=avg(dt.process.memory.usage), by: { dt.entity.process_group_instance } | fieldsAdd memory_usage = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{memory_usage}, executionOrder:leftFirst | lookup [ timeseries values=avg(dt.process.network.bytes_rx), by: { dt.entity.process_group_instance } | fieldsAdd net_rx = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{net_rx}, executionOrder:leftFirst | lookup [ timeseries values=avg(dt.process.network.bytes_tx), by: { dt.entity.process_group_instance } | fieldsAdd net_tx = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{net_tx}, executionOrder:leftFirst | lookup [ fetch dt.entity.process_group_instance | fieldsAdd host_id = belongs_to[dt.entity.host], process_name = entity.name | lookup [ fetch dt.entity.host | fields id, hostname = entity.name, hostGroupName ], sourceField:host_id, lookupField:id, prefix:"result." ], sourceField:dt.entity.process_group_instance, lookupField:id, fields:{result.hostname} | fieldsRemove `avg(dt.process.cpu.usage)` | sort cpu_usage desc</LI-CODE><P>&nbsp;</P> Fri, 11 Jul 2025 01:47:57 GMT Emm4nuel 2025-07-11T01:47:57Z https://community.dynatrace.com/t5/DQL/listing-the-most-consuming-processes-in-terms-of-Network-CPU/m-p/280729#M2248 <P>I need a custom query to fetch the most consuming processes in terms of:</P><UL><LI>Network utilization</LI><LI>Memory</LI><LI>CPU</LI><LI>Disk</LI></UL><P>also splitting by each host to pinpoint directly to the most saturated hosts.</P><P>Thanks.&nbsp;</P> Thu, 03 Jul 2025 14:33:40 GMT https://community.dynatrace.com/t5/DQL/listing-the-most-consuming-processes-in-terms-of-Network-CPU/m-p/280729#M2248 Peter_Youssef 2025-07-03T14:33:40Z https://community.dynatrace.com/t5/DQL/listing-the-most-consuming-processes-in-terms-of-Network-CPU/m-p/281337#M2289 <P>Hey Peter,</P><P>I spent some time on this and got as close as I could. It seems like not many have tried a query like this before. I couldn’t sort all fields due to inconsistent values, so I stuck with sorting by<SPAN>&nbsp;</SPAN>cpu_usage.</P><P>Hope this helps!</P><P><BR /><BR /></P><LI-CODE lang="javascript">timeseries avg(dt.process.cpu.usage), by: { dt.entity.process_group_instance } | fieldsAdd dt.entity.process_group_instance.name = entityName(dt.entity.process_group_instance) | fieldsAdd cpu_usage = arrayAvg(`avg(dt.process.cpu.usage)`) | lookup [ timeseries values=avg(dt.process.io.bytes_total), by: { dt.entity.process_group_instance } | fieldsAdd io_usage = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{io_usage}, executionOrder:leftFirst | lookup [ timeseries values=avg(dt.process.memory.usage), by: { dt.entity.process_group_instance } | fieldsAdd memory_usage = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{memory_usage}, executionOrder:leftFirst | lookup [ timeseries values=avg(dt.process.network.bytes_rx), by: { dt.entity.process_group_instance } | fieldsAdd net_rx = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{net_rx}, executionOrder:leftFirst | lookup [ timeseries values=avg(dt.process.network.bytes_tx), by: { dt.entity.process_group_instance } | fieldsAdd net_tx = arrayAvg(values) ], sourceField:dt.entity.process_group_instance, lookupField:dt.entity.process_group_instance, fields:{net_tx}, executionOrder:leftFirst | lookup [ fetch dt.entity.process_group_instance | fieldsAdd host_id = belongs_to[dt.entity.host], process_name = entity.name | lookup [ fetch dt.entity.host | fields id, hostname = entity.name, hostGroupName ], sourceField:host_id, lookupField:id, prefix:"result." ], sourceField:dt.entity.process_group_instance, lookupField:id, fields:{result.hostname} | fieldsRemove `avg(dt.process.cpu.usage)` | sort cpu_usage desc</LI-CODE><P>&nbsp;</P> Fri, 11 Jul 2025 01:47:57 GMT https://community.dynatrace.com/t5/DQL/listing-the-most-consuming-processes-in-terms-of-Network-CPU/m-p/281337#M2289 Emm4nuel 2025-07-11T01:47:57Z https://community.dynatrace.com/t5/DQL/listing-the-most-consuming-processes-in-terms-of-Network-CPU/m-p/281339#M2291 <DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class=""><P>Use the table view, not line or area graph</P></DIV></DIV></DIV></DIV></DIV> Fri, 11 Jul 2025 01:53:04 GMT https://community.dynatrace.com/t5/DQL/listing-the-most-consuming-processes-in-terms-of-Network-CPU/m-p/281339#M2291 Emm4nuel 2025-07-11T01:53:04Z