# DQL

**URL:** https://community.dynatrace.com/c/platform/dql/83.md?page=5

[Latest](https://community.dynatrace.com/latest.md) · [Categories](https://community.dynatrace.com/categories.md) · [Tags](https://community.dynatrace.com/tags.md)

**Page:** 6

---

## [Filter timeseries using Request Attribute](https://community.dynatrace.com/t/filter-timeseries-using-request-attribute/54516)

<div class="topic-metadata">

**Author:** [@Vincent\_L](https://community.dynatrace.com/u/Vincent_L)\
**Replies:** 1\
**Last updated:** [January 1, 2026, 10:04pm UTC](https://community.dynatrace.com/t/filter-timeseries-using-request-attribute/54516 "2026-01-01T22:04:13Z")

</div>

Hello! I’ve been stuck for a few weeks because of this problem… I need to get KPIs for requests in a service (number, average, p90, p95). But, I need to use a request attribute in my filters to split the requests. Unf…

---

## [Is there a way to get a list of all entity types in Grail (so something synonymous to the /entityTypes classic v2 API)?](https://community.dynatrace.com/t/is-there-a-way-to-get-a-list-of-all-entity-types-in-grail-so-something-synonymous-to-the-entitytypes-classic-v2-api/53499)

<div class="topic-metadata">

**Author:** [@36Krazyfists](https://community.dynatrace.com/u/36Krazyfists)\
**Replies:** 5\
**Last updated:** [December 30, 2025, 10:48pm UTC](https://community.dynatrace.com/t/is-there-a-way-to-get-a-list-of-all-entity-types-in-grail-so-something-synonymous-to-the-entitytypes-classic-v2-api/53499 "2025-12-30T22:48:35Z")

</div>

I know if I just start typing dt.entity. the auto-complete in the DQL query box will offer suggestions, but I want to be able to just get a list of all dt.entity.f5 types in a table. The result I want would look like: E…

---

## [Determine Start Time in DQL Queries for Accurate Analysis](https://community.dynatrace.com/t/determine-start-time-in-dql-queries-for-accurate-analysis/52987)

<div class="topic-metadata">

**Author:** [@deni](https://community.dynatrace.com/u/deni)\
**Replies:** 4\
**Last updated:** [December 30, 2025, 10:46am UTC](https://community.dynatrace.com/t/determine-start-time-in-dql-queries-for-accurate-analysis/52987 "2025-12-30T10:46:01Z")

</div>

Hi, I have the following two queries and wondering what is the difference: fetch spans | makeTimeseries sum(duration) fetch spans | makeTimeseries sum(duration), time:start\_time I tried both in Playground, but I can’…

---

## [How to display entity name of affected entityID for problems of different entity types in Dashboard](https://community.dynatrace.com/t/how-to-display-entity-name-of-affected-entityid-for-problems-of-different-entity-types-in-dashboard/54497)

<div class="topic-metadata">

**Author:** [@Mani\_Muthu3001](https://community.dynatrace.com/u/Mani_Muthu3001)\
**Replies:** 2\
**Last updated:** [December 29, 2025, 3:38pm UTC](https://community.dynatrace.com/t/how-to-display-entity-name-of-affected-entityid-for-problems-of-different-entity-types-in-dashboard/54497 "2025-12-29T15:38:29Z")

</div>

Hi, I am creating dashboard to find reoccurence of problems and count the reoccurrence . But I want entity name for affected entity id instead of entity id to show in dashboard. We have mutliple entity types in our envi…

---

## [Multiline Data limit](https://community.dynatrace.com/t/multiline-data-limit/54485)

<div class="topic-metadata">

**Author:** [@anujjain504](https://community.dynatrace.com/u/anujjain504)\
**Replies:** 1\
**Last updated:** [December 24, 2025, 9:38am UTC](https://community.dynatrace.com/t/multiline-data-limit/54485 "2025-12-24T09:38:39Z")

</div>

I have to parse data at search time using “parse content”. However, we know that “DATA” has default limit 4096 bytes. So, what if I have to collect specific content beyond default limit 4096 bytes? I tried DATA\* but it…

---

## [Is it possible to analyse Fields and Field Values](https://community.dynatrace.com/t/is-it-possible-to-analyse-fields-and-field-values/54478)

<div class="topic-metadata">

**Author:** [@backscratcher](https://community.dynatrace.com/u/backscratcher)\
**Replies:** 0\
**Last updated:** [December 23, 2025, 1:02pm UTC](https://community.dynatrace.com/t/is-it-possible-to-analyse-fields-and-field-values/54478 "2025-12-23T13:02:13Z")

</div>

Hi there, I have some event data coming in and I query it using DQL. The data represents configuration of a system and is not too large at approx 3000 records each with a variable number of fields between 10 and 100. M…

---

## [DQL example to share - To aid in development for creating status rules](https://community.dynatrace.com/t/dql-example-to-share-to-aid-in-development-for-creating-status-rules/54469)

<div class="topic-metadata">

**Author:** [@elton1899](https://community.dynatrace.com/u/elton1899)\
**Replies:** 0\
**Last updated:** [December 22, 2025, 8:25pm UTC](https://community.dynatrace.com/t/dql-example-to-share-to-aid-in-development-for-creating-status-rules/54469 "2025-12-22T20:25:39Z")

</div>

timeseries valor = max(Nome\_metrica), by:{device.address, device.name, dt.metrics.source, device.port, device} | fieldsAdd lista\_limpa = arrayRemoveNulls(valor) | fieldsAdd lista = arrayReverse(lista\_limpa) | fieldsA…

---

## [Dashboard Menu Input Parameters - internal key and human key](https://community.dynatrace.com/t/dashboard-menu-input-parameters-internal-key-and-human-key/43611)

<div class="topic-metadata">

**Author:** [@HeadScratcher](https://community.dynatrace.com/u/HeadScratcher)\
**Replies:** 5\
**Last updated:** [December 19, 2025, 9:27am UTC](https://community.dynatrace.com/t/dashboard-menu-input-parameters-internal-key-and-human-key/43611 "2025-12-19T09:27:11Z")

</div>

I have a a dashboard that runs some DQL based on an input parameter called $AppChoice. This functions fine but is really anti-user friendly as the AppChoice is a kind of private key in our organisation i.e. just a refer…

---

## [DQL 'entities isn't a valid data object' when trying to fetch entities](https://community.dynatrace.com/t/dql-entities-isnt-a-valid-data-object-when-trying-to-fetch-entities/43869)

<div class="topic-metadata">

**Author:** [@sivart\_89](https://community.dynatrace.com/u/sivart_89)\
**Replies:** 5\
**Last updated:** [December 19, 2025, 9:26am UTC](https://community.dynatrace.com/t/dql-entities-isnt-a-valid-data-object-when-trying-to-fetch-entities/43869 "2025-12-19T09:26:17Z")

</div>

When I run some like the first DQL below it works fine. In the result one field is the query string which notes the 2nd DQL. However, entities does not seem to exist as I get a '‘entities isn’t a valid data object’ conne…

---

## [Filter and Analyse Problem Events with Dynatrace DQL](https://community.dynatrace.com/t/filter-and-analyse-problem-events-with-dynatrace-dql/45498)

<div class="topic-metadata">

**Author:** [@RPbiaggio](https://community.dynatrace.com/u/RPbiaggio)\
**Replies:** 6\
**Last updated:** [December 19, 2025, 8:49am UTC](https://community.dynatrace.com/t/filter-and-analyse-problem-events-with-dynatrace-dql/45498 "2025-12-19T08:49:01Z")

</div>

Guys, can you help me with the case below? I need to get only active (open) problems. This is happening, however, I am not able to bring the tags I need. As I’m getting takeMax, I think it’s not returning the informatio…

---

## [Return Last Known Value in Time-Series Using DQL makeTimeseries](https://community.dynatrace.com/t/return-last-known-value-in-time-series-using-dql-maketimeseries/50355)

<div class="topic-metadata">

**Author:** [@dekidekide](https://community.dynatrace.com/u/dekidekide)\
**Replies:** 7\
**Last updated:** [December 18, 2025, 10:25pm UTC](https://community.dynatrace.com/t/return-last-known-value-in-time-series-using-dql-maketimeseries/50355 "2025-12-18T22:25:09Z")

</div>

Hi, I have a data/logs for job run status, which logs records for “Success” or “Fail” each run - job runs anytime base on schedule (e.i. 1-3 times a day and/or can be run manually). i’m tying to use makeTimeseries to ca…

---

## [Extract Entity Relationships Using classicEntitySelector in DQL](https://community.dynatrace.com/t/extract-entity-relationships-using-classicentityselector-in-dql/50665)

<div class="topic-metadata">

**Author:** [@paolo\_fumanelli](https://community.dynatrace.com/u/paolo_fumanelli)\
**Replies:** 5\
**Last updated:** [December 18, 2025, 9:42pm UTC](https://community.dynatrace.com/t/extract-entity-relationships-using-classicentityselector-in-dql/50665 "2025-12-18T21:42:58Z")

</div>

Hi, when extracting relationships with DQL I often get into this warning. See for istance the following: the usage of classicEntitySelector is suggested is best practices for such cases but how can I get the same res…

---

## [List All Hosts Under a Management Zone Using DQL](https://community.dynatrace.com/t/list-all-hosts-under-a-management-zone-using-dql/46789)

<div class="topic-metadata">

**Author:** [@bdahan](https://community.dynatrace.com/u/bdahan)\
**Replies:** 5\
**Last updated:** [December 18, 2025, 6:46pm UTC](https://community.dynatrace.com/t/list-all-hosts-under-a-management-zone-using-dql/46789 "2025-12-18T18:46:31Z")

</div>

how to list all hosts under a drop-down management zone using DQL in GEN2? looking for a code where .. when selecting given management zone from drop-down .. It will list all hosts under this management zone on other dr…

---

## [Create a Metric from a value other than DQL Matcher](https://community.dynatrace.com/t/create-a-metric-from-a-value-other-than-dql-matcher/46055)

<div class="topic-metadata">

**Author:** [@DanielS](https://community.dynatrace.com/u/DanielS)\
**Replies:** 8\
**Last updated:** [December 18, 2025, 6:03pm UTC](https://community.dynatrace.com/t/create-a-metric-from-a-value-other-than-dql-matcher/46055 "2025-12-18T18:03:04Z")

</div>

Hello Community, I need to create a metric from a value using the countDistinct function and to save that value over time, the DQL query is the following: fetch logs | FILTER matchesValue(k8s.container.name, "onboardin…

---

## [Keep Latest Logs with Custom Processing Rules in DQL](https://community.dynatrace.com/t/keep-latest-logs-with-custom-processing-rules-in-dql/45892)

<div class="topic-metadata">

**Author:** [@AlexisGND](https://community.dynatrace.com/u/AlexisGND)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 2:26pm UTC](https://community.dynatrace.com/t/keep-latest-logs-with-custom-processing-rules-in-dql/45892 "2025-12-18T14:26:59Z")

</div>

Hello, I want to make a processing rule to filter out an entire log. Here’s the log sample : \[ { "interface.name": "Seq\_SAP\_to\_AGV", "host.environment": "PROD", "host.name": "Datastage", "c…

---

## [Limit Fetch Table Size in Lookup Commands Using DQL](https://community.dynatrace.com/t/limit-fetch-table-size-in-lookup-commands-using-dql/46070)

<div class="topic-metadata">

**Author:** [@r\_weber](https://community.dynatrace.com/u/r_weber)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 2:23pm UTC](https://community.dynatrace.com/t/limit-fetch-table-size-in-lookup-commands-using-dql/46070 "2025-12-18T14:23:33Z")

</div>

I’m trying to make a lookup as efficient as possible, thus I’d require to provide a dynamic filter to the “fetch” command within a lookup. Take this code: fetch spans | filter k8s.namespace.name == "webshop-frontend" |…

---

## [Monitor Database Health in Dynatrace’s New Dashboard UI](https://community.dynatrace.com/t/monitor-database-health-in-dynatrace-s-new-dashboard-ui/46315)

<div class="topic-metadata">

**Author:** [@Gib80](https://community.dynatrace.com/u/Gib80)\
**Replies:** 4\
**Last updated:** [December 18, 2025, 2:13pm UTC](https://community.dynatrace.com/t/monitor-database-health-in-dynatrace-s-new-dashboard-ui/46315 "2025-12-18T14:13:24Z")

</div>

Hi Everyone, Within dashboards classic we have the option to add a database health tile which works with no problems. I want to recreate this in the new dashboards UI, is this possible? Thanks

---

## [Compare Columns Across Multiple Query Executions Using DQL](https://community.dynatrace.com/t/compare-columns-across-multiple-query-executions-using-dql/49281)

<div class="topic-metadata">

**Author:** [@rseibert1](https://community.dynatrace.com/u/rseibert1)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 2:03pm UTC](https://community.dynatrace.com/t/compare-columns-across-multiple-query-executions-using-dql/49281 "2025-12-18T14:03:28Z")

</div>

I have a workflow that has the below DQL task, I want to run and compare executions of this and create a list (of new unhealthy workers). fetch logs | filter contains(log.tag, “octopus\_workers”) | parse content, “JSON…

---

## [Fetch Spans to Calculate Duration in Distributed Traces Using DQL](https://community.dynatrace.com/t/fetch-spans-to-calculate-duration-in-distributed-traces-using-dql/51307)

<div class="topic-metadata">

**Author:** [@StrangerThing](https://community.dynatrace.com/u/StrangerThing)\
**Replies:** 4\
**Last updated:** [December 18, 2025, 2:03pm UTC](https://community.dynatrace.com/t/fetch-spans-to-calculate-duration-in-distributed-traces-using-dql/51307 "2025-12-18T14:03:28Z")

</div>

I’m trying to mimic the way duration of a trace is shown in the Distributed Tracing apps. I’m getting very, very close but seem to be missing something. I realize this may be slightly different depending on the applicati…

---

## [Create Alerts for Multiple Location Failures Using DQL](https://community.dynatrace.com/t/create-alerts-for-multiple-location-failures-using-dql/48768)

<div class="topic-metadata">

**Author:** [@sivart\_89](https://community.dynatrace.com/u/sivart_89)\
**Replies:** 4\
**Last updated:** [December 18, 2025, 2:01pm UTC](https://community.dynatrace.com/t/create-alerts-for-multiple-location-failures-using-dql/48768 "2025-12-18T14:01:49Z")

</div>

I’m trying to essentially duplicate this type of alerting but with a custom alert in the Davis anomaly detection app. What I’m struggling most with is the ‘3 times consecutively’ part. The synthetic I am working with run…

---

## [Filter Fields by Value Using DQL Queries for Precise Results](https://community.dynatrace.com/t/filter-fields-by-value-using-dql-queries-for-precise-results/48101)

<div class="topic-metadata">

**Author:** [@JhonU](https://community.dynatrace.com/u/JhonU)\
**Replies:** 5\
**Last updated:** [December 18, 2025, 2:01pm UTC](https://community.dynatrace.com/t/filter-fields-by-value-using-dql-queries-for-precise-results/48101 "2025-12-18T14:01:20Z")

</div>

Hello everyone, could you help me because I am stuck, through a DQL query I get the following fields based on aggregations, the last thing I need is to be able to filter and only present the fields whose numeric value is…

---

## [Use DQL Alternative to New Relic’s EXTRAPOLATE Command](https://community.dynatrace.com/t/use-dql-alternative-to-new-relic-s-extrapolate-command/49032)

<div class="topic-metadata">

**Author:** [@Ganesh\_Reddy](https://community.dynatrace.com/u/Ganesh_Reddy)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 12:55pm UTC](https://community.dynatrace.com/t/use-dql-alternative-to-new-relic-s-extrapolate-command/49032 "2025-12-18T12:55:24Z")

</div>

Could you please let me know if there is an alternative to New Relic’s EXTRAPOLATE command? This command is used to fill in missing gaps when calculating time-series data etc, ensuring smooth and continuous data represen…

---

## [Export Inactive Applications in RUM Using DQL Queries](https://community.dynatrace.com/t/export-inactive-applications-in-rum-using-dql-queries/49859)

<div class="topic-metadata">

**Author:** [@vishnu\_kumar](https://community.dynatrace.com/u/vishnu_kumar)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 12:43pm UTC](https://community.dynatrace.com/t/export-inactive-applications-in-rum-using-dql-queries/49859 "2025-12-18T12:43:19Z")

</div>

Hi, We have some applications that has “No user actions during past” besides its name, which have no traffic for a timeframe in “Frontend” page. I used these “Query User sessions” with USQL as same timeframe as Fronten…

---

## [Resolve JVM GC Collection Time and Count Discrepancies Using DQL](https://community.dynatrace.com/t/resolve-jvm-gc-collection-time-and-count-discrepancies-using-dql/50205)

<div class="topic-metadata">

**Author:** [@koushickpatel](https://community.dynatrace.com/u/koushickpatel)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 12:36pm UTC](https://community.dynatrace.com/t/resolve-jvm-gc-collection-time-and-count-discrepancies-using-dql/50205 "2025-12-18T12:36:23Z")

</div>

Hi, I am trying set up a query for jvm gc.collection\_time & gc.collection\_count. timeseries avg(dt.runtime.jvm.gc.collection\_time), by: { host.name }, filter: { (host.name == xxxx)} timeseries avg(dt.runtime.jvm.gc.co…

---

## [Detect Synthetic Location Failures Using DQL for Alerting](https://community.dynatrace.com/t/detect-synthetic-location-failures-using-dql-for-alerting/50298)

<div class="topic-metadata">

**Author:** [@sivart\_89](https://community.dynatrace.com/u/sivart_89)\
**Replies:** 5\
**Last updated:** [December 18, 2025, 12:33pm UTC](https://community.dynatrace.com/t/detect-synthetic-location-failures-using-dql-for-alerting/50298 "2025-12-18T12:33:56Z")

</div>

I’m trying to essentially replicate this type of built-in alert, to a dql and davis anomaly detector. What would the dql look like for a synthetic that runs every 5 minutes at 5 different locations where I want to alert …

---

## [Access Azure VM and AWS EC2 Power Status Using DQL](https://community.dynatrace.com/t/access-azure-vm-and-aws-ec2-power-status-using-dql/50418)

<div class="topic-metadata">

**Author:** [@2181](https://community.dynatrace.com/u/2181)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 12:27pm UTC](https://community.dynatrace.com/t/access-azure-vm-and-aws-ec2-power-status-using-dql/50418 "2025-12-18T12:27:00Z")

</div>

Hi Community, Is it possible to access the cloud VM running status from DQL? In the integration there is a staus field. This seems to be correct even if for some reason the platform-level metrics are not showing correc…

---

## [Use DQL Alternative to Dedup for Efficient Data Filtering](https://community.dynatrace.com/t/use-dql-alternative-to-dedup-for-efficient-data-filtering/50468)

<div class="topic-metadata">

**Author:** [@CecilieFosbo](https://community.dynatrace.com/u/CecilieFosbo)\
**Replies:** 4\
**Last updated:** [December 18, 2025, 12:25pm UTC](https://community.dynatrace.com/t/use-dql-alternative-to-dedup-for-efficient-data-filtering/50468 "2025-12-18T12:25:34Z")

</div>

I hope someone can help with this. We have a field sak, which represent the caseId, which is uniqe. We have many traces/records with the same case ID representing each step the uniqe case is beeing processed in a busine…

---

## [Export OneAgent Health Data Using DQL Queries](https://community.dynatrace.com/t/export-oneagent-health-data-using-dql-queries/50507)

<div class="topic-metadata">

**Author:** [@vishnu\_kumar](https://community.dynatrace.com/u/vishnu_kumar)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 12:22pm UTC](https://community.dynatrace.com/t/export-oneagent-health-data-using-dql-queries/50507 "2025-12-18T12:22:13Z")

</div>

Hi, Is it possible to get the results of Oneagent Health on a DQL query? I mean this page: OneAgent health overview — Dynatrace Docs I found that the Env V2 API, monitoringstate does it. (Correct me if wrong) For…

---

## [Configure Task Input Loops for Nested Lists Using DQL](https://community.dynatrace.com/t/configure-task-input-loops-for-nested-lists-using-dql/51488)

<div class="topic-metadata">

**Author:** [@brandon\_camp](https://community.dynatrace.com/u/brandon_camp)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 10:48am UTC](https://community.dynatrace.com/t/configure-task-input-loops-for-nested-lists-using-dql/51488 "2025-12-18T10:48:10Z")

</div>

This is related to my prior topic here https://community.dynatrace.com/t5/DQL/Davis-Analyzer-limits-how-to-chunk-up-the-dimensions/td-p/275485 and I found a similar issue but could not follow its advice here https://comm…

---

## [Remove Null Fields from Query Results Using DQL](https://community.dynatrace.com/t/remove-null-fields-from-query-results-using-dql/51506)

<div class="topic-metadata">

**Author:** [@36Krazyfists](https://community.dynatrace.com/u/36Krazyfists)\
**Replies:** 7\
**Last updated:** [December 18, 2025, 10:47am UTC](https://community.dynatrace.com/t/remove-null-fields-from-query-results-using-dql/51506 "2025-12-18T10:47:13Z")

</div>

I need to be able to check a field and, if it’s null, remove it. Yes, I can do that for a single field easy by just saying something like: fetch logs | filter isNull(someField) | removeFields someField But what if I h…

[Previous page](https://community.dynatrace.com/c/platform/dql/83.md?page=4)

[Next page](https://community.dynatrace.com/c/platform/dql/83.md?page=6)
