# DQL

**URL:** https://community.dynatrace.com/c/platform/dql/83.md

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

---

## [Use makeTimeseries with fetch entity for Advanced DQL Time-Series Queries](https://community.dynatrace.com/t/use-maketimeseries-with-fetch-entity-for-advanced-dql-time-series-queries/49206)

<div class="topic-metadata">

**Author:** [@FShimaya](https://community.dynatrace.com/u/FShimaya)\
**Replies:** 3\
**Last updated:** [November 19, 2026, 5:42am UTC](https://community.dynatrace.com/t/use-maketimeseries-with-fetch-entity-for-advanced-dql-time-series-queries/49206 "2026-11-19T05:42:01Z")

</div>

I would like a DQL statement (either in Dashboard or Notebook) to perform the following query and result in an event so that query results are alertable depending on the threshold. In this case, I would like an event ge…

---

## [Fix Issues with ArrayMovingSum and Davis Anomaly Detection in DQL](https://community.dynatrace.com/t/fix-issues-with-arraymovingsum-and-davis-anomaly-detection-in-dql/49556)

<div class="topic-metadata">

**Author:** [@wellpplava](https://community.dynatrace.com/u/wellpplava)\
**Replies:** 6\
**Last updated:** [November 18, 2026, 8:26am UTC](https://community.dynatrace.com/t/fix-issues-with-arraymovingsum-and-davis-anomaly-detection-in-dql/49556 "2026-11-18T08:26:17Z")

</div>

Hello everyone, I’m encountering some issues while using ArrayMovingSum together with DavisAnomalyDetection and would like to know if anyone has faced something similar or has suggestions. I’m trying to use it as an al…

---

## [Percentiles in Anomaly Detection Alerts](https://community.dynatrace.com/t/percentiles-in-anomaly-detection-alerts/57323)

<div class="topic-metadata">

**Author:** [@arobayo17](https://community.dynatrace.com/u/arobayo17)\
**Replies:** 2\
**Last updated:** [October 30, 2026, 3:11am UTC](https://community.dynatrace.com/t/percentiles-in-anomaly-detection-alerts/57323 "2026-10-30T03:11:58Z")

</div>

Hi everyone, I’m trying to create an anomaly detector based on a DQL query using span duration. fetch spans //| filter transaction.is\_root\_span AND transaction.is\_endpoint\_request | filter matchesValue(endpoint.name…

---

## [Multiple metric not working](https://community.dynatrace.com/t/multiple-metric-not-working/57162)

<div class="topic-metadata">

**Author:** [@Vijayt](https://community.dynatrace.com/u/Vijayt)\
**Replies:** 3\
**Last updated:** [October 16, 2026, 3:01am UTC](https://community.dynatrace.com/t/multiple-metric-not-working/57162 "2026-10-16T03:01:08Z")

</div>

we have infrastructure mode and classic dashboard only my requirement is to have display server , crowdstrike cpu % and Servercpu% . for server , crowdstrike cpu % i used query https://community.dynatrace.com/t5/Open…

---

## [Is there a way to query Settings via DQL?](https://community.dynatrace.com/t/is-there-a-way-to-query-settings-via-dql/54544)

<div class="topic-metadata">

**Author:** [@36Krazyfists](https://community.dynatrace.com/u/36Krazyfists)\
**Replies:** 3\
**Last updated:** [October 14, 2026, 11:49am UTC](https://community.dynatrace.com/t/is-there-a-way-to-query-settings-via-dql/54544 "2026-10-14T11:49:59Z")

</div>

For example, I’d like to get a list of all of our configured Davis Anomaly Detectors that contain the word “Mail” in them so that I can easily pass on a report of what alerts are setup for our Email (Exchange) team. I d…

---

## [how to create  dql to check database failed connection](https://community.dynatrace.com/t/how-to-create-dql-to-check-database-failed-connection/51041)

<div class="topic-metadata">

**Author:** [@heramb\_sawant](https://community.dynatrace.com/u/heramb_sawant)\
**Replies:** 3\
**Last updated:** [October 13, 2026, 7:12am UTC](https://community.dynatrace.com/t/how-to-create-dql-to-check-database-failed-connection/51041 "2026-10-13T07:12:12Z")

</div>

Hi have created dashboard tile using builtin:service.dbconnections.failure, this shows failed connection count. I want to imeplement the same using DQL , how I can do that. I did not find matching key in grail metric …

---

## [use builtin: formula to get list of host and their properties in that management zone](https://community.dynatrace.com/t/use-builtin-formula-to-get-list-of-host-and-their-properties-in-that-management-zone/57112)

<div class="topic-metadata">

**Author:** [@ushag](https://community.dynatrace.com/u/ushag)\
**Replies:** 1\
**Last updated:** [October 9, 2026, 6:40am UTC](https://community.dynatrace.com/t/use-builtin-formula-to-get-list-of-host-and-their-properties-in-that-management-zone/57112 "2026-10-09T06:40:33Z")

</div>

How can I use a builtin: query to list all my host and their IP builtin:pgi.availability.state:filter(in(“dt.entity.host”,entitySelector(“type(~“HOST~”), tag(~”\[Environment\]IP:~“)”)))

---

## [Enable Deep Monitoring of Processes Using DQL Queries](https://community.dynatrace.com/t/enable-deep-monitoring-of-processes-using-dql-queries/51775)

<div class="topic-metadata">

**Author:** [@tsagredo](https://community.dynatrace.com/u/tsagredo)\
**Replies:** 6\
**Last updated:** [October 1, 2026, 7:46am UTC](https://community.dynatrace.com/t/enable-deep-monitoring-of-processes-using-dql-queries/51775 "2026-10-01T07:46:30Z")

</div>

Hello! Does anyone know if I can graph the following information from a host process on a notebook? Deep monitoring

---

## [Unexpected records in Running polling result](https://community.dynatrace.com/t/unexpected-records-in-running-polling-result/57047)

<div class="topic-metadata">

**Author:** [@coder33](https://community.dynatrace.com/u/coder33)\
**Replies:** 1\
**Last updated:** [October 1, 2026, 6:24am UTC](https://community.dynatrace.com/t/unexpected-records-in-running-polling-result/57047 "2026-10-01T06:24:25Z")

</div>

I am seeing “records” in the response from “apps.dynatrace.com/platform/storage/query/v1/query:poll” when the state is still RUNNING. I was not expecting to get any “records” until the state changed to SUCCEEDED. Does …

---

## [use metric dimension as a value in a timeseries query](https://community.dynatrace.com/t/use-metric-dimension-as-a-value-in-a-timeseries-query/56959)

<div class="topic-metadata">

**Author:** [@dougwillis](https://community.dynatrace.com/u/dougwillis)\
**Replies:** 1\
**Last updated:** [September 17, 2026, 6:08am UTC](https://community.dynatrace.com/t/use-metric-dimension-as-a-value-in-a-timeseries-query/56959 "2026-09-17T06:08:16Z")

</div>

I have some metrics coming into Dynatrace from a Prometheus scrape. The metric shows up as pg\_meta\_info and has a static value of 1 but many values setup as dimensions. One of these dimesnsions is version\_num which cont…

---

## [How to filter OpenTelemetry array attributes in OpenPipeline Dynamic Routing?](https://community.dynatrace.com/t/how-to-filter-opentelemetry-array-attributes-in-openpipeline-dynamic-routing/56943)

<div class="topic-metadata">

**Author:** [@Carl\_Me](https://community.dynatrace.com/u/Carl_Me)\
**Replies:** 1\
**Last updated:** [September 15, 2026, 7:29pm UTC](https://community.dynatrace.com/t/how-to-filter-opentelemetry-array-attributes-in-openpipeline-dynamic-routing/56943 "2026-09-15T19:29:12Z")

</div>

Hi everyone, I’m looking for some guidance regarding OpenPipeline Dynamic Routing and filtering OpenTelemetry array attributes. I receive log records containing an attribute that is stored as an array, for example: \[…

---

## [Shift Time Frame In a Dashboard Using a Input Variable](https://community.dynatrace.com/t/shift-time-frame-in-a-dashboard-using-a-input-variable/56822)

<div class="topic-metadata">

**Author:** [@victor\_correa](https://community.dynatrace.com/u/victor_correa)\
**Replies:** 3\
**Last updated:** [September 14, 2026, 4:15pm UTC](https://community.dynatrace.com/t/shift-time-frame-in-a-dashboard-using-a-input-variable/56822 "2026-09-14T16:15:14Z")

</div>

I’m building a comparative transaction dashboard that should display day for the current time frame but also data shifted by a number of days that will be a variable input. The goal is to be able to show current data ve…

---

## [Parse a string with special characters](https://community.dynatrace.com/t/parse-a-string-with-special-characters/56884)

<div class="topic-metadata">

**Author:** [@slhempen](https://community.dynatrace.com/u/slhempen)\
**Replies:** 1\
**Last updated:** [September 4, 2026, 2:30pm UTC](https://community.dynatrace.com/t/parse-a-string-with-special-characters/56884 "2026-09-04T14:30:00Z")

</div>

I have this string in a message field that needs to be parsed. I need the values between the double quotes extracted into separate fields. I am having a hard time getting the correct syntax to handle eliminating ‘\<’, ‘…

---

## [Issue with dt.host.availability](https://community.dynatrace.com/t/issue-with-dt-host-availability/56801)

<div class="topic-metadata">

**Author:** [@Jo\_oSilva](https://community.dynatrace.com/u/Jo_oSilva)\
**Replies:** 5\
**Last updated:** [August 27, 2026, 5:51pm UTC](https://community.dynatrace.com/t/issue-with-dt-host-availability/56801 "2026-08-27T17:51:11Z")

</div>

Can someone explain why does this DQL query return Host Unavailable for any host every 5 minutes? If we change the interval to another value, it seems to return host\_unavailable at multiples of that interval. The condi…

---

## [RUM DQL Queries](https://community.dynatrace.com/t/rum-dql-queries/56660)

<div class="topic-metadata">

**Author:** [@Ganeshmete77](https://community.dynatrace.com/u/Ganeshmete77)\
**Replies:** 4\
**Last updated:** [August 11, 2026, 4:45pm UTC](https://community.dynatrace.com/t/rum-dql-queries/56660 "2026-08-11T16:45:11Z")

</div>

Hi Team, i have below user session queries, i am looking for similar queries in DQL. “userActionDuration” : f’SELECT AVG(useraction.duration),useraction.name FROM usersession WHERE userType=“REAL\_USER” AND userevent.pa…

---

## [Sum Entities by Specific Tag Using DQL for Aggregated Insights](https://community.dynatrace.com/t/sum-entities-by-specific-tag-using-dql-for-aggregated-insights/52936)

<div class="topic-metadata">

**Author:** [@TylerJVitale](https://community.dynatrace.com/u/TylerJVitale)\
**Replies:** 2\
**Last updated:** [August 11, 2026, 3:21pm UTC](https://community.dynatrace.com/t/sum-entities-by-specific-tag-using-dql-for-aggregated-insights/52936 "2026-08-11T15:21:39Z")

</div>

I am trying to create a report with a count of all the entities that have a specific tag value, and then \*of those\*, another specific value. My current DQL looks like this: fetch dt.entity.host | filter tags ~ “specif…

---

## [Budget Summary Graph Dashboard via DQL](https://community.dynatrace.com/t/budget-summary-graph-dashboard-via-dql/56637)

<div class="topic-metadata">

**Author:** [@CharlesPerez](https://community.dynatrace.com/u/CharlesPerez)\
**Replies:** 1\
**Last updated:** [August 11, 2026, 6:52am UTC](https://community.dynatrace.com/t/budget-summary-graph-dashboard-via-dql/56637 "2026-08-11T06:52:51Z")

</div>

We have a client that wants to create a License allocation and budget summary graph dashboard via DQL, the one usually found in account management. Thank you.

---

## [Find out request count per node vs total request count](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649)

<div class="topic-metadata">

**Author:** [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Replies:** 5\
**Last updated:** [August 10, 2026, 3:59pm UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649 "2026-08-10T15:59:52Z")

</div>

Hi, I need to set up an alert when the distribution of a particular request is not even across the different nodes. To do that, I need to find out the percentage of load based on the load/per node vs total load. I am t…

---

## [How to consolidate data into a sum within timeseries](https://community.dynatrace.com/t/how-to-consolidate-data-into-a-sum-within-timeseries/56609)

<div class="topic-metadata">

**Author:** [@Hillman](https://community.dynatrace.com/u/Hillman)\
**Replies:** 3\
**Last updated:** [August 5, 2026, 4:00am UTC](https://community.dynatrace.com/t/how-to-consolidate-data-into-a-sum-within-timeseries/56609 "2026-08-05T04:00:33Z")

</div>

Currently I am use the following DQL to list out the web request count for our API calls: timeseries { sum(webrequest) }, by: { http.response.status\_code, server.address, TenantID, Tenant, url.path } | fieldsAdd Tenant …

---

## [Querying to find the most costly ingested metrics](https://community.dynatrace.com/t/querying-to-find-the-most-costly-ingested-metrics/55950)

<div class="topic-metadata">

**Author:** [@siavash1996](https://community.dynatrace.com/u/siavash1996)\
**Replies:** 5\
**Last updated:** [August 3, 2026, 7:53am UTC](https://community.dynatrace.com/t/querying-to-find-the-most-costly-ingested-metrics/55950 "2026-08-03T07:53:27Z")

</div>

Hi there, I’m trying to find a way to query grail to find the most expensive metrics that we are ingesting via API. In Gen2, it was pretty easy to get an idea of the cost of custom metrics, but I have been unable to fin…

---

## [Deep Monitoring - Hosts](https://community.dynatrace.com/t/deep-monitoring-hosts/56606)

<div class="topic-metadata">

**Author:** [@Mateusbmo1](https://community.dynatrace.com/u/Mateusbmo1)\
**Replies:** 2\
**Last updated:** [July 31, 2026, 12:33am UTC](https://community.dynatrace.com/t/deep-monitoring-hosts/56606 "2026-07-31T00:33:30Z")

</div>

Hello Everyone, good afternoon! How are you? I recently started working intensively on FinOps in Dynatrace, and I’ve begun automating some processes. I created a script to replace all Full-Stack hosts with Infrastruc…

---

## [How to Replace certain part of URL in a log content](https://community.dynatrace.com/t/how-to-replace-certain-part-of-url-in-a-log-content/50806)

<div class="topic-metadata">

**Author:** [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Replies:** 5\
**Last updated:** [July 30, 2026, 3:22pm UTC](https://community.dynatrace.com/t/how-to-replace-certain-part-of-url-in-a-log-content/50806 "2026-07-30T15:22:06Z")

</div>

I have a log content like this : URL: /v1/agreements/12345678/vins/xx123456KL456/validate How can I replace the 3rd and 5th portion so that for all vins and agreements # dynatrace treat them as same url ?

---

## [StringProperties fields and action name field cannot be found in DQL.](https://community.dynatrace.com/t/stringproperties-fields-and-action-name-field-cannot-be-found-in-dql/55758)

<div class="topic-metadata">

**Author:** [@jestinwang](https://community.dynatrace.com/u/jestinwang)\
**Replies:** 3\
**Last updated:** [July 29, 2026, 10:53am UTC](https://community.dynatrace.com/t/stringproperties-fields-and-action-name-field-cannot-be-found-in-dql/55758 "2026-07-29T10:53:16Z")

</div>

hello, we added some configs to capture the data from EUM and can save these information in user action. they can be inquired by USQL. but how to leverage DQL to capture these information? Thank you, Jestin

---

## [Live sessions metric with sum aggregation](https://community.dynatrace.com/t/live-sessions-metric-with-sum-aggregation/56580)

<div class="topic-metadata">

**Author:** [@elenaperez](https://community.dynatrace.com/u/elenaperez)\
**Replies:** 0\
**Last updated:** [July 28, 2026, 8:46am UTC](https://community.dynatrace.com/t/live-sessions-metric-with-sum-aggregation/56580 "2026-07-28T08:46:56Z")

</div>

Hi team, When we go to a specific process and check the live sessions, we see 18 However, when we check with the data explorer we see different numbers (108 with Sum and 3.6 with Average) The only way we can …

---

## [Percentile calculation](https://community.dynatrace.com/t/percentile-calculation/56154)

<div class="topic-metadata">

**Author:** [@enrico\_afkl](https://community.dynatrace.com/u/enrico_afkl)\
**Replies:** 11\
**Last updated:** [July 17, 2026, 7:09am UTC](https://community.dynatrace.com/t/percentile-calculation/56154 "2026-07-17T07:09:39Z")

</div>

Hello, I have this query and would like to find out which endpoints fall within the 98th percentile: timeseries { totalCalls = sum(log.prgoffer.foapi.baminfo.httpmethod, filter: isNotNull(endpoint)), successCalls = …

---

## [Return True if Pattern is found anywhere within Text - Help](https://community.dynatrace.com/t/return-true-if-pattern-is-found-anywhere-within-text-help/56394)

<div class="topic-metadata">

**Author:** [@badgerfifteen](https://community.dynatrace.com/u/badgerfifteen)\
**Replies:** 2\
**Last updated:** [July 9, 2026, 11:06am UTC](https://community.dynatrace.com/t/return-true-if-pattern-is-found-anywhere-within-text-help/56394 "2026-07-09T11:06:57Z")

</div>

Hi, I am formulating a DPL command to return true if a pattern such as a credit card format/number exists anywhere within a piece of text. For example… data record(a = "378282246310005") | parse a, """CREDITCARD:cc"""…

---

## [Need help to filter data according to time range in DQL](https://community.dynatrace.com/t/need-help-to-filter-data-according-to-time-range-in-dql/56397)

<div class="topic-metadata">

**Author:** [@ravi\_singh](https://community.dynatrace.com/u/ravi_singh)\
**Replies:** 1\
**Last updated:** [July 9, 2026, 7:55am UTC](https://community.dynatrace.com/t/need-help-to-filter-data-according-to-time-range-in-dql/56397 "2026-07-09T07:55:56Z")

</div>

timeseries terminal\_up = max(httpcheck.status), filter: { host.type == “terminal” and http.status\_class == “2xx” }, by: { hostName = host.name, storeId = store.name }, interval: 1m | fieldsAdd is\_up = if(terminal\_up\[…

---

## [Permissions in Grail](https://community.dynatrace.com/t/permissions-in-grail/56377)

<div class="topic-metadata">

**Author:** [@rhea\_b2905](https://community.dynatrace.com/u/rhea_b2905)\
**Replies:** 1\
**Last updated:** [July 7, 2026, 2:03pm UTC](https://community.dynatrace.com/t/permissions-in-grail/56377 "2026-07-07T14:03:10Z")

</div>

Hello, I am trying to aet up permissions in grail to access query execution endpoints. I was trying to follow the instructions listed here: Permissions in Grail — Dynatrace Docs however, Im failing to find step 2 of th…

---

## [How to filter the service request with a particular request name?](https://community.dynatrace.com/t/how-to-filter-the-service-request-with-a-particular-request-name/56366)

<div class="topic-metadata">

**Author:** [@Hillman](https://community.dynatrace.com/u/Hillman)\
**Replies:** 7\
**Last updated:** [July 7, 2026, 1:56am UTC](https://community.dynatrace.com/t/how-to-filter-the-service-request-with-a-particular-request-name/56366 "2026-07-07T01:56:13Z")

</div>

We have a process group which include a bunch of process. The processes are started but only 1 of them is the active process and would initiate a particular web request. The other processes are standby and will not trigg…

---

## [DQL costs when querying spans – looking for advice](https://community.dynatrace.com/t/dql-costs-when-querying-spans-looking-for-advice/55403)

<div class="topic-metadata">

**Author:** [@michiel\_otten](https://community.dynatrace.com/u/michiel_otten)\
**Replies:** 2\
**Last updated:** [July 3, 2026, 1:51am UTC](https://community.dynatrace.com/t/dql-costs-when-querying-spans-looking-for-advice/55403 "2026-07-03T01:51:25Z")

</div>

Hi everyone, I’m looking for advice on managing and controlling query costs in DQL, especially when working with spans. In my recent experiments, I’ve been querying spans for about 1–2 hours, even with a 500GB limit in…

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