# DQL

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

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

**Page:** 4

---

## [DQL query Problems does not return comments](https://community.dynatrace.com/t/dql-query-problems-does-not-return-comments/55196)

<div class="topic-metadata">

**Author:** [@cusack\_christop](https://community.dynatrace.com/u/cusack_christop)\
**Replies:** 1\
**Last updated:** [March 6, 2026, 7:09am UTC](https://community.dynatrace.com/t/dql-query-problems-does-not-return-comments/55196 "2026-03-06T07:09:53Z")

</div>

How do you get the Comments back in a DQL query when querying dt.davis.problems? I can see the comments in the UI for a given Problem but cannot see a column name that displays this data in DQL. I’ve already tried most…

---

## [Using if condition in summarize](https://community.dynatrace.com/t/using-if-condition-in-summarize/54749)

<div class="topic-metadata">

**Author:** [@shaima](https://community.dynatrace.com/u/shaima)\
**Replies:** 3\
**Last updated:** [March 5, 2026, 4:08pm UTC](https://community.dynatrace.com/t/using-if-condition-in-summarize/54749 "2026-03-05T16:08:14Z")

</div>

Hello, I’ve been asked to aggregate metric dimensions for a dashboard.The metric has over 100 dimensions. Each dimension represents a numeric value ranging from 0 to 150. The customer provided predefined groups, and I n…

---

## [Filtering high-cardinality timeseries data by value](https://community.dynatrace.com/t/filtering-high-cardinality-timeseries-data-by-value/55170)

<div class="topic-metadata">

**Author:** [@Rudolph\_Sedlin](https://community.dynatrace.com/u/Rudolph_Sedlin)\
**Replies:** 4\
**Last updated:** [March 4, 2026, 7:06pm UTC](https://community.dynatrace.com/t/filtering-high-cardinality-timeseries-data-by-value/55170 "2026-03-04T19:06:44Z")

</div>

Hey all. I have very-high-cardinality timeseries data that I send over to Dynatrace. To prevent the dashboard tiles from crashing and to allow alerting workflows to complete in a timely manner, I use iAny filter stateme…

---

## [Question about problem states in dt.davis.problems](https://community.dynatrace.com/t/question-about-problem-states-in-dt-davis-problems/49246)

<div class="topic-metadata">

**Author:** [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Replies:** 3\
**Last updated:** [March 4, 2026, 6:32pm UTC](https://community.dynatrace.com/t/question-about-problem-states-in-dt-davis-problems/49246 "2026-03-04T18:32:37Z")

</div>

Hello, Does anybody know (or has a table) what all the states and transitions are? What is the difference between active/update and active refresh? Being in the subject what is the benefit of the dt.davis.problem.s…

---

## [DQL - Recursive array to column extraction](https://community.dynatrace.com/t/dql-recursive-array-to-column-extraction/55166)

<div class="topic-metadata">

**Author:** [@Yann\_Buccellato](https://community.dynatrace.com/u/Yann_Buccellato)\
**Replies:** 7\
**Last updated:** [March 4, 2026, 12:19pm UTC](https://community.dynatrace.com/t/dql-recursive-array-to-column-extraction/55166 "2026-03-04T12:19:24Z")

</div>

Hello community, I have an array which is build as follow (it contains 2 elements): \[ { "text": "Brave new world xx.xx.xxxx of xxxxxx and", "id": "021(anastasia)", "index": "0" }, { "text": "Brave new world but old", "…

---

## [DQL for Successful vs Failed Product Transfers by brand (Logs on Grail vs Classic)](https://community.dynatrace.com/t/dql-for-successful-vs-failed-product-transfers-by-brand-logs-on-grail-vs-classic/54312)

<div class="topic-metadata">

**Author:** [@arunshetty2281](https://community.dynatrace.com/u/arunshetty2281)\
**Replies:** 2\
**Last updated:** [March 4, 2026, 12:13pm UTC](https://community.dynatrace.com/t/dql-for-successful-vs-failed-product-transfers-by-brand-logs-on-grail-vs-classic/54312 "2026-03-04T12:13:44Z")

</div>

We need to chart Successful vs Failed requests per brand from application logs. The brands are logged in the message body (JSON fragments like “brand”:“Bradford”), and success is indicated by “offerAccepted”:“Y”. This is…

---

## [Display dt-system-bucket Field in DQL Queries for Complete Results](https://community.dynatrace.com/t/display-dt-system-bucket-field-in-dql-queries-for-complete-results/52471)

<div class="topic-metadata">

**Author:** [@szimsley](https://community.dynatrace.com/u/szimsley)\
**Replies:** 5\
**Last updated:** [March 2, 2026, 4:09pm UTC](https://community.dynatrace.com/t/display-dt-system-bucket-field-in-dql-queries-for-complete-results/52471 "2026-03-02T16:09:51Z")

</div>

Is there a reason the dt.system.bucket field is not displayed by default, and is there any plan to change that so users have better access to filtering info?

---

## [dql query for summarize count ofthis endpoint](https://community.dynatrace.com/t/dql-query-for-summarize-count-ofthis-endpoint/55151)

<div class="topic-metadata">

**Author:** [@gasperetta](https://community.dynatrace.com/u/gasperetta)\
**Replies:** 1\
**Last updated:** [March 2, 2026, 10:59am UTC](https://community.dynatrace.com/t/dql-query-for-summarize-count-ofthis-endpoint/55151 "2026-03-02T10:59:34Z")

</div>

hi, i need the count of all value of this 3 endpoint. How can i do this? timeseries calls\_per\_min = sum(dt.service.request.count, rate:1m), by:{endpoint.name, dt.entity.service, dt.host\_group.id}, interval: 1m | field…

---

## [DQL - Execution](https://community.dynatrace.com/t/dql-execution/55086)

<div class="topic-metadata">

**Author:** [@munawarhossain3](https://community.dynatrace.com/u/munawarhossain3)\
**Replies:** 6\
**Last updated:** [February 27, 2026, 2:47pm UTC](https://community.dynatrace.com/t/dql-execution/55086 "2026-02-27T14:47:47Z")

</div>

Hello, How can I achieve this with DQL? Trigger an error if the 5XX error rate \> 1% of the 2XX / 15m I’ve a timeseries metric preceding to the above condition. Thanks MH

---

## [DQL query for Disk utilization](https://community.dynatrace.com/t/dql-query-for-disk-utilization/55128)

<div class="topic-metadata">

**Author:** [@ravi\_singh](https://community.dynatrace.com/u/ravi_singh)\
**Replies:** 1\
**Last updated:** [February 27, 2026, 8:38am UTC](https://community.dynatrace.com/t/dql-query-for-disk-utilization/55128 "2026-02-27T08:38:59Z")

</div>

I want help in DQL query for k8s workload for disk utilization - The workload can be deployment or statefulset (like mongodb, rabbitmq) Q1. Can you help me DQL query for a deployment workload? Q2 for statefulset I can…

---

## [Parsing Logs for Concurrent Connections](https://community.dynatrace.com/t/parsing-logs-for-concurrent-connections/54482)

<div class="topic-metadata">

**Author:** [@idudneymitchell](https://community.dynatrace.com/u/idudneymitchell)\
**Replies:** 2\
**Last updated:** [February 26, 2026, 5:49pm UTC](https://community.dynatrace.com/t/parsing-logs-for-concurrent-connections/54482 "2026-02-26T17:49:00Z")

</div>

I have a query into my logs that looks something like this: fetch log | filter matchesValue(dt.entity.process\_group\_instance, “the-process-im-looking-at”) | parse content, “TIMESTAMP:DATETIME LD ’ 443 - ’ LD:REQADDR ’…

---

## [Current request count vs baseline](https://community.dynatrace.com/t/current-request-count-vs-baseline/55011)

<div class="topic-metadata">

**Author:** [@OnkarShinde](https://community.dynatrace.com/u/OnkarShinde)\
**Replies:** 4\
**Last updated:** [February 25, 2026, 3:20pm UTC](https://community.dynatrace.com/t/current-request-count-vs-baseline/55011 "2026-02-25T15:20:54Z")

</div>

I am trying to create a DQL to measure the current request count as percentage of the baseline. I intend to use it in an SLO configuration. I tried something like this: timeseries { today=sum(dt.service.request.count),…

---

## [Datadog - Calendar-based rollup in Dynatrace (weekly/monthly/yearly with custom start & timezone)](https://community.dynatrace.com/t/datadog-calendar-based-rollup-in-dynatrace-weekly-monthly-yearly-with-custom-start-timezone/55104)

<div class="topic-metadata">

**Author:** [@anuj08\_jain](https://community.dynatrace.com/u/anuj08_jain)\
**Replies:** 1\
**Last updated:** [February 25, 2026, 2:59pm UTC](https://community.dynatrace.com/t/datadog-calendar-based-rollup-in-dynatrace-weekly-monthly-yearly-with-custom-start-timezone/55104 "2026-02-25T14:59:12Z")

</div>

Hello Team, In Datadog dashboards, we can configure rollups like: avg weekly UTC starting Sunday avg monthly UTC starting \<date\> avg yearly UTC starting \<month\> In Dynatrace, I can use every \<interval\> for fixed rol…

---

## [Why does a DQL query with the same filtering return different counts from one with a Segment?](https://community.dynatrace.com/t/why-does-a-dql-query-with-the-same-filtering-return-different-counts-from-one-with-a-segment/55089)

<div class="topic-metadata">

**Author:** [@gary-rogers](https://community.dynatrace.com/u/gary-rogers)\
**Replies:** 4\
**Last updated:** [February 24, 2026, 6:58pm UTC](https://community.dynatrace.com/t/why-does-a-dql-query-with-the-same-filtering-return-different-counts-from-one-with-a-segment/55089 "2026-02-24T18:58:23Z")

</div>

When I run this query without a segment I get 9 records: fetch dt.davis.problems | filter event.status == "ACTIVE" | filter matchesValue(k8s.cluster.name, { "production-01", "production-02", "production-03", "production…

---

## [dt.entity.\* deprecated](https://community.dynatrace.com/t/dt-entity-deprecated/55058)

<div class="topic-metadata">

**Author:** [@ljonsson](https://community.dynatrace.com/u/ljonsson)\
**Replies:** 1\
**Last updated:** [February 20, 2026, 7:16pm UTC](https://community.dynatrace.com/t/dt-entity-deprecated/55058 "2026-02-20T19:16:02Z")

</div>

I noticed the other day that DQL has started flagging dt.entity.host as deprecated. Is this really true? It seems to me that such a change will break almost everything. Here’s a couple incomplete DQL queries to illust…

---

## [How do I get the last values of a string using the parse command?](https://community.dynatrace.com/t/how-do-i-get-the-last-values-of-a-string-using-the-parse-command/55033)

<div class="topic-metadata">

**Author:** [@badgerfifteen](https://community.dynatrace.com/u/badgerfifteen)\
**Replies:** 1\
**Last updated:** [February 18, 2026, 12:55pm UTC](https://community.dynatrace.com/t/how-do-i-get-the-last-values-of-a-string-using-the-parse-command/55033 "2026-02-18T12:55:48Z")

</div>

Hi, I’m having trouble understanding the DPL documentation. What I want to do is extract the last characters after a certain character, in this case it would be ‘/’. I am trying to extract just the filename from the str…

---

## [Access Main Technology of individual processes](https://community.dynatrace.com/t/access-main-technology-of-individual-processes/47953)

<div class="topic-metadata">

**Author:** [@Javin\_Singh](https://community.dynatrace.com/u/Javin_Singh)\
**Replies:** 5\
**Last updated:** [February 18, 2026, 9:35am UTC](https://community.dynatrace.com/t/access-main-technology-of-individual-processes/47953 "2026-02-18T09:35:18Z")

</div>

Within a DQL query, I am trying to filter processes based on the “Main Technology” of each process group, e.g. “Dynatrace” and “Elasticsearch”. However, I can’t seem to find the variable containing the “Main Technology” …

---

## [Using regex for a path](https://community.dynatrace.com/t/using-regex-for-a-path/54972)

<div class="topic-metadata">

**Author:** [@nisah](https://community.dynatrace.com/u/nisah)\
**Replies:** 5\
**Last updated:** [February 13, 2026, 6:51pm UTC](https://community.dynatrace.com/t/using-regex-for-a-path/54972 "2026-02-13T18:51:59Z")

</div>

Hi - I had the below regex working fine in a workflow “| filter matchesRegex(lower(cicd.pipeline.url.full),”.\*/\\\\.github/workflows/.\*(ci|standard).\*\\\\.ya?ml$“)” Now i’m getting the below error for the same. Is there …

---

## [Segments: include entities and related metrics/traces](https://community.dynatrace.com/t/segments-include-entities-and-related-metrics-traces/54993)

<div class="topic-metadata">

**Author:** [@janne-olkoniemi](https://community.dynatrace.com/u/janne-olkoniemi)\
**Replies:** 1\
**Last updated:** [February 13, 2026, 12:58pm UTC](https://community.dynatrace.com/t/segments-include-entities-and-related-metrics-traces/54993 "2026-02-13T12:58:58Z")

</div>

I have just started to play around with segments and I hope that someone could help me how to include metrics and traces from entities to be part of segment definition. I have currently the following variable in place o…

---

## [Dynatrace API v2: Manage monitored entities - Deprecated in SaaS](https://community.dynatrace.com/t/dynatrace-api-v2-manage-monitored-entities-deprecated-in-saas/54757)

<div class="topic-metadata">

**Author:** [@Carl\_Me](https://community.dynatrace.com/u/Carl_Me)\
**Replies:** 6\
**Last updated:** [February 10, 2026, 10:16pm UTC](https://community.dynatrace.com/t/dynatrace-api-v2-manage-monitored-entities-deprecated-in-saas/54757 "2026-02-10T22:16:35Z")

</div>

Hello, It seems that it’s no longer possible to view an entity’s properties using the v2 API (/entities) - see image. Do you have an example of a DQL query that returns all the properties as the API used to? We have …

---

## [DQL count datapoints](https://community.dynatrace.com/t/dql-count-datapoints/54797)

<div class="topic-metadata">

**Author:** [@tore\_davidsen1](https://community.dynatrace.com/u/tore_davidsen1)\
**Replies:** 3\
**Last updated:** [February 10, 2026, 4:29pm UTC](https://community.dynatrace.com/t/dql-count-datapoints/54797 "2026-02-10T16:29:26Z")

</div>

I\`m trying to create a dashboard showing the % of data points where there was active problems. I figure that if I can count the number of data points where the value of problems is \>0, then divide it with the total numbe…

---

## [Understanding Dynatrace service.requestCount metrics (total vs client vs server)](https://community.dynatrace.com/t/understanding-dynatrace-service-requestcount-metrics-total-vs-client-vs-server/54946)

<div class="topic-metadata">

**Author:** [@R928492](https://community.dynatrace.com/u/R928492)\
**Replies:** 0\
**Last updated:** [February 10, 2026, 2:58pm UTC](https://community.dynatrace.com/t/understanding-dynatrace-service-requestcount-metrics-total-vs-client-vs-server/54946 "2026-02-10T14:58:39Z")

</div>

We would like to understand the difference between the below three query of DT inbuilt matrices : builtin:service.requestCount.total:filter(and(or(in(“dt.entity.service”,entitySelector(“type(service),entityName.equals(~…

---

## [DQL - the last backup value from sqlserver](https://community.dynatrace.com/t/dql-the-last-backup-value-from-sqlserver/54943)

<div class="topic-metadata">

**Author:** [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Replies:** 2\
**Last updated:** [February 10, 2026, 11:45am UTC](https://community.dynatrace.com/t/dql-the-last-backup-value-from-sqlserver/54943 "2026-02-10T11:45:36Z")

</div>

Hello, I want to use the last backup value from sqlserver to create a dashboard showing the last backup time and date. Problem the value returned is in minutes passed… Who known or has already a way to converted this …

---

## [Filtering Kafka metrics in Dynatrace for specific brokers and consumers](https://community.dynatrace.com/t/filtering-kafka-metrics-in-dynatrace-for-specific-brokers-and-consumers/54933)

<div class="topic-metadata">

**Author:** [@koti521](https://community.dynatrace.com/u/koti521)\
**Replies:** 2\
**Last updated:** [February 10, 2026, 10:02am UTC](https://community.dynatrace.com/t/filtering-kafka-metrics-in-dynatrace-for-specific-brokers-and-consumers/54933 "2026-02-10T10:02:10Z")

</div>

we have a single Dynatrace for multiple Kafka instances. I want to filter it out to my Kafka brokers and consumers. I want to filter my Kafka brokers and producer information only, instead of displaying all other produc…

---

## [Create SLOs for Synthetic Browser Monitors Using DQL](https://community.dynatrace.com/t/create-slos-for-synthetic-browser-monitors-using-dql/50654)

<div class="topic-metadata">

**Author:** [@robin\_vogels](https://community.dynatrace.com/u/robin_vogels)\
**Replies:** 4\
**Last updated:** [February 9, 2026, 4:05pm UTC](https://community.dynatrace.com/t/create-slos-for-synthetic-browser-monitors-using-dql/50654 "2026-02-09T16:05:55Z")

</div>

I would like to create a SLO for synthetic browser monitor duration \< 2000ms. I successfully created a SLO for HTTP synthetic monitors, but I’m struggling to get the same working for synthetic browser monitors. Can anyb…

---

## [Add Node.js Event Loop Metrics to Dashboards V2 Using DQL](https://community.dynatrace.com/t/add-node-js-event-loop-metrics-to-dashboards-v2-using-dql/45671)

<div class="topic-metadata">

**Author:** [@mouru](https://community.dynatrace.com/u/mouru)\
**Replies:** 5\
**Last updated:** [February 9, 2026, 8:23am UTC](https://community.dynatrace.com/t/add-node-js-event-loop-metrics-to-dashboards-v2-using-dql/45671 "2026-02-09T08:23:03Z")

</div>

Hi, I’m trying to get timeseries tiles about common Node.js event loop metrics to be viewed in Dashboards V2, but the tile seems to show false values ( around 5% avg.) When the host event loop dashboard shows values arou…

---

## [RUM - User query](https://community.dynatrace.com/t/rum-user-query/54913)

<div class="topic-metadata">

**Author:** [@LTanyap](https://community.dynatrace.com/u/LTanyap)\
**Replies:** 1\
**Last updated:** [February 9, 2026, 2:01am UTC](https://community.dynatrace.com/t/rum-user-query/54913 "2026-02-09T02:01:36Z")

</div>

I am looking for a DQL script to query a daily count of users for a particular application and generate a table.

---

## [makeTimeseries in DQL with lookupField](https://community.dynatrace.com/t/maketimeseries-in-dql-with-lookupfield/54866)

<div class="topic-metadata">

**Author:** [@scholcia](https://community.dynatrace.com/u/scholcia)\
**Replies:** 5\
**Last updated:** [February 4, 2026, 11:18am UTC](https://community.dynatrace.com/t/maketimeseries-in-dql-with-lookupfield/54866 "2026-02-04T11:18:21Z")

</div>

How to create makeTimeseries in this DQL to be able to create alert from it : timeseries { uptime = avg(com.dynatrace.extension.network\_device.sysuptime), by: { \`dt.entity.network:device\` }, interval:1m } | fieldsAdd …

---

## [how to get normalized builtin:host.cpu.load5m](https://community.dynatrace.com/t/how-to-get-normalized-builtin-host-cpu-load5m/54828)

<div class="topic-metadata">

**Author:** [@Vijayt](https://community.dynatrace.com/u/Vijayt)\
**Replies:** 6\
**Last updated:** [February 3, 2026, 5:36am UTC](https://community.dynatrace.com/t/how-to-get-normalized-builtin-host-cpu-load5m/54828 "2026-02-03T05:36:00Z")

</div>

i have access to only classic dashboard . builtin:host.cpu.load5m - shows overall . server load i am want to create alert if builtin:host.cpu.load5m/ cpu count \>1.5 but i dont see any option to use cpu count in metr…

---

## [Get Kubernetes Pod status](https://community.dynatrace.com/t/get-kubernetes-pod-status/54846)

<div class="topic-metadata">

**Author:** [@ashokpjana](https://community.dynatrace.com/u/ashokpjana)\
**Replies:** 1\
**Last updated:** [February 2, 2026, 9:39pm UTC](https://community.dynatrace.com/t/get-kubernetes-pod-status/54846 "2026-02-02T21:39:15Z")

</div>

have the cluster name and namespace details. Can I get the below details through DQL? Pods stuck in Pending/Unschedulable state Pods in CrashLoopBackOff or Failed state Nodes in NotReady/Unhealthy state Pod scheduling …

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

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