# \#dql

**URL:** https://community.dynatrace.com/tag/dql/675.md

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

---

## [How to access the bizevent payload in the next step in workflow](https://community.dynatrace.com/t/how-to-access-the-bizevent-payload-in-the-next-step-in-workflow/57998)

<div class="topic-metadata">

**Author:** [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Replies:** 1\
**Last updated:** [November 21, 2026, 9:42pm UTC](https://community.dynatrace.com/t/how-to-access-the-bizevent-payload-in-the-next-step-in-workflow/57998 "2026-11-21T21:42:48Z")

</div>

I am creating a workflow which will be triggered by bizevent, I want to access one of the unique data from the payload, how do I access it ? Any help is appreciated.

---

## [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…

---

## [How to get synthetic availability using DQL on Dashboard?](https://community.dynatrace.com/t/how-to-get-synthetic-availability-using-dql-on-dashboard/51561)

<div class="topic-metadata">

**Author:** [@heramb\_sawant](https://community.dynatrace.com/u/heramb_sawant)\
**Replies:** 2\
**Last updated:** [November 16, 2026, 1:50pm UTC](https://community.dynatrace.com/t/how-to-get-synthetic-availability-using-dql-on-dashboard/51561 "2026-11-16T13:50:12Z")

</div>

Hi, I want to show synthetic availability % on new dashboard using DQL. Can somebody please help on this .Does Grail has all the classic metrics of synthetic using DQL + timeseries. i did not find any example in d…

---

## [New feature Base Query on dashboards](https://community.dynatrace.com/t/new-feature-base-query-on-dashboards/57518)

<div class="topic-metadata">

**Author:** [@RaphaelM1](https://community.dynatrace.com/u/RaphaelM1)\
**Replies:** 4\
**Last updated:** [November 4, 2026, 8:59pm UTC](https://community.dynatrace.com/t/new-feature-base-query-on-dashboards/57518 "2026-11-04T20:59:11Z")

</div>

Hello everyone! A “Base Query” feature recently appeared in my environment; the explanation is that a single query can be used throughout an entire dashboard. I’ve run a few tests, but I haven’t been able to apply addi…

---

## [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:~“)”)))

---

## [Per-disk low disk space alerting with individual thresholds at scale](https://community.dynatrace.com/t/per-disk-low-disk-space-alerting-with-individual-thresholds-at-scale/57062)

<div class="topic-metadata">

**Author:** [@Jo\_oSilva](https://community.dynatrace.com/u/Jo_oSilva)\
**Replies:** 5\
**Last updated:** [October 5, 2026, 10:42am UTC](https://community.dynatrace.com/t/per-disk-low-disk-space-alerting-with-individual-thresholds-at-scale/57062 "2026-10-05T10:42:55Z")

</div>

We are currently trying to resolve an issue with low disk space problems in our Dynatrace environment. Dynatrace is opening low disk space problems for a large number of discovered disks, but the client never requested …

---

## [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 …

---

## [classic entity to smartscape functions conversion](https://community.dynatrace.com/t/classic-entity-to-smartscape-functions-conversion/55217)

<div class="topic-metadata">

**Author:** [@R928492](https://community.dynatrace.com/u/R928492)\
**Replies:** 4\
**Last updated:** [September 30, 2026, 8:09pm UTC](https://community.dynatrace.com/t/classic-entity-to-smartscape-functions-conversion/55217 "2026-09-30T20:09:44Z")

</div>

timeseries { count = sum( dt.service.request.count, scalar: true, filter: { ( in( dt.entity.service, classicEntitySelector( …

---

## [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…

---

## [Bidirectional Synthetic Monitoring (cloud evni ↔ OnPrem) and Correlated Alerting Best Practice](https://community.dynatrace.com/t/bidirectional-synthetic-monitoring-cloud-evni-onprem-and-correlated-alerting-best-practice/56691)

<div class="topic-metadata">

**Author:** [@gauravpayghan](https://community.dynatrace.com/u/gauravpayghan)\
**Replies:** 1\
**Last updated:** [September 10, 2026, 6:21am UTC](https://community.dynatrace.com/t/bidirectional-synthetic-monitoring-cloud-evni-onprem-and-correlated-alerting-best-practice/56691 "2026-09-10T06:21:17Z")

</div>

We are designing bidirectional synthetic monitoring where: AWS environment monitors 2 endpoints hosted in OnPrem OnPrem environment monitors 2 endpoints hosted in AWS We are evaluating the best monitoring approach: D…

---

## [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…

---

## [User.events custom bucket for faster dashboards — is data copied or moved?](https://community.dynatrace.com/t/user-events-custom-bucket-for-faster-dashboards-is-data-copied-or-moved/56687)

<div class="topic-metadata">

**Author:** [@gauravpayghan](https://community.dynatrace.com/u/gauravpayghan)\
**Replies:** 2\
**Last updated:** [August 11, 2026, 3:34pm UTC](https://community.dynatrace.com/t/user-events-custom-bucket-for-faster-dashboards-is-data-copied-or-moved/56687 "2026-08-11T15:34:57Z")

</div>

have a dashboard on the user.events table. Each event has ~35 fields, but my dashboard uses only 3. Queries get slow on wider timeframes because they scan the full default bucket. I want a custom bucket with just the dat…

---

## [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 …

---

## [USQL vs DQL: different session counts, contradictory docs on active sessions, and User Action Properties not available in Grail?](https://community.dynatrace.com/t/usql-vs-dql-different-session-counts-contradictory-docs-on-active-sessions-and-user-action-properties-not-available-in-grail/56315)

<div class="topic-metadata">

**Author:** [@v\_mayordomo](https://community.dynatrace.com/u/v_mayordomo)\
**Replies:** 3\
**Last updated:** [August 3, 2026, 9:56am UTC](https://community.dynatrace.com/t/usql-vs-dql-different-session-counts-contradictory-docs-on-active-sessions-and-user-action-properties-not-available-in-grail/56315 "2026-08-03T09:56:34Z")

</div>

Hi Team, We are building new Grail-based dashboards (Document app) for our RUM-monitored web applications. To add business context to sessions, we configured User Action Properties that capture JavaScript variables from…

---

## [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…

---

## [Debugging faulty API access tenant side?](https://community.dynatrace.com/t/debugging-faulty-api-access-tenant-side/56613)

<div class="topic-metadata">

**Author:** [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\
**Replies:** 1\
**Last updated:** [August 2, 2026, 11:49pm UTC](https://community.dynatrace.com/t/debugging-faulty-api-access-tenant-side/56613 "2026-08-02T23:49:21Z")

</div>

I have debugged API access inside dt.system.events, using several approaches (origin.address,authentication.token, etc.), but I don’t seem to get errors. I can get successful ones, but not those giving 401s/404s/etc. I …

---

## [Workflow cross-tenant?](https://community.dynatrace.com/t/workflow-cross-tenant/56547)

<div class="topic-metadata">

**Author:** [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Replies:** 3\
**Last updated:** [July 31, 2026, 7:31am UTC](https://community.dynatrace.com/t/workflow-cross-tenant/56547 "2026-07-31T07:31:05Z")

</div>

Hi, We have a workflow which execute DQL queries and send a report with problems opened by email. Some entities are in another tenant. Do we have a way to get those problems, in another tenant, in same workflow? Have …

[Next page](https://community.dynatrace.com/tag/dql/675.md?match_all_tags=true&page=1&tags%5B%5D=dql)
