# DQL

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

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

**Page:** 2

---

## [Graph showing the response time of outgoing services](https://community.dynatrace.com/t/graph-showing-the-response-time-of-outgoing-services/56343)

<div class="topic-metadata">

**Author:** [@albertokirey](https://community.dynatrace.com/u/albertokirey)\
**Replies:** 3\
**Last updated:** [July 2, 2026, 12:35pm UTC](https://community.dynatrace.com/t/graph-showing-the-response-time-of-outgoing-services/56343 "2026-07-02T12:35:30Z")

</div>

Hello everyone, I’d like to create a graph showing the response times of calls to other services that my Mulesoft service makes (and maybe also the failure rate). It’s similar to what’s already available in the Services…

---

## [Fetch enhanced endpoints](https://community.dynatrace.com/t/fetch-enhanced-endpoints/56349)

<div class="topic-metadata">

**Author:** [@tesp11331](https://community.dynatrace.com/u/tesp11331)\
**Replies:** 4\
**Last updated:** [July 2, 2026, 10:45am UTC](https://community.dynatrace.com/t/fetch-enhanced-endpoints/56349 "2026-07-02T10:45:35Z")

</div>

Hi All, how can I fetch with a DQL query the endpoint of a service after enhancing the new feature of Enhanced Endpoints ? Trying with fetch dt.entity.service\_method I get only the old key request, how can I query al…

---

## [How to make a new Timeseries by calculating data from 2 individual Timeseries?](https://community.dynatrace.com/t/how-to-make-a-new-timeseries-by-calculating-data-from-2-individual-timeseries/56284)

<div class="topic-metadata">

**Author:** [@Hillman](https://community.dynatrace.com/u/Hillman)\
**Replies:** 5\
**Last updated:** [July 2, 2026, 3:33am UTC](https://community.dynatrace.com/t/how-to-make-a-new-timeseries-by-calculating-data-from-2-individual-timeseries/56284 "2026-07-02T03:33:08Z")

</div>

As the PostgreSQL extension does not ingest the Cache Hit Ratio metrics, we have to do manual calculation with the following formula: 100 \* blocks\_hit / ( blocks\_hit + blocks\_read ) blocks\_hit and blocks\_read are 2 Tim…

---

## [Bug Found - DQL usable\_with field shows wrong fields](https://community.dynatrace.com/t/bug-found-dql-usable-with-field-shows-wrong-fields/56236)

<div class="topic-metadata">

**Author:** [@Maheedhar\_T](https://community.dynatrace.com/u/Maheedhar_T)\
**Replies:** 2\
**Last updated:** [July 1, 2026, 11:21am UTC](https://community.dynatrace.com/t/bug-found-dql-usable-with-field-shows-wrong-fields/56236 "2026-07-01T11:21:55Z")

</div>

Hi Team, As per the latest SaaS release, the documentation says Extended meta information on data objects in Grail The dt.system.data\_objects fetch command now includes a new field usable\_with field in its output fetc…

---

## [Why is this so hard -- Simple log parsing](https://community.dynatrace.com/t/why-is-this-so-hard-simple-log-parsing/56298)

<div class="topic-metadata">

**Author:** [@jim\_hinze](https://community.dynatrace.com/u/jim_hinze)\
**Replies:** 3\
**Last updated:** [June 26, 2026, 6:14am UTC](https://community.dynatrace.com/t/why-is-this-so-hard-simple-log-parsing/56298 "2026-06-26T06:14:32Z")

</div>

Sometimes this works, sometimes it does not… and quite frankly, the documentation is not helpful. Here is a log entry: Jun 25 15:31:20 HOSTNAME CEF:0|Netwrix|Activity Monitor|9.0.1477|Windows File SystemReadTrueFalse|Fi…

---

## [Export list of services & associated metrics from legacy AWS role-based integration](https://community.dynatrace.com/t/export-list-of-services-associated-metrics-from-legacy-aws-role-based-integration/56206)

<div class="topic-metadata">

**Author:** [@AK](https://community.dynatrace.com/u/AK)\
**Replies:** 0\
**Last updated:** [June 17, 2026, 5:27am UTC](https://community.dynatrace.com/t/export-list-of-services-associated-metrics-from-legacy-aws-role-based-integration/56206 "2026-06-17T05:27:40Z")

</div>

Hello Community, I need help retrieving a list of all services and their associated metrics that are enabled through the legacy AWS integration (role-based authentication) across our AWS accounts. Can this be done via A…

---

## [Unsupported Splunk command pivot.](https://community.dynatrace.com/t/unsupported-splunk-command-pivot/56176)

<div class="topic-metadata">

**Author:** [@anuj-jain08](https://community.dynatrace.com/u/anuj-jain08)\
**Replies:** 1\
**Last updated:** [June 14, 2026, 11:51pm UTC](https://community.dynatrace.com/t/unsupported-splunk-command-pivot/56176 "2026-06-14T23:51:30Z")

</div>

Hello Team, Is there any workarounds or way to convert Splunk query using \`| pivot\` Example | pivot Tutorial HTTP\_requests count(HTTP\_requests) AS “Total Requests” Any way to convert this query?

---

## [Dynatrace alert created by Davis Anomaly Detection is not triggering with the given DQL](https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140)

<div class="topic-metadata">

**Author:** [@ravi\_singh](https://community.dynatrace.com/u/ravi_singh)\
**Replies:** 3\
**Last updated:** [June 12, 2026, 12:10am UTC](https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140 "2026-06-12T00:10:15Z")

</div>

PROBLEM STATEMENT:- I m using the below query for creating an alert using davis anomaly detetcor, my alert configs are:- threshold: 2 sliding window - 5 violating samples - 1 dealerting samples - 3 So this is showi…

---

## [Graph the number of requests to a service according to response time](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975)

<div class="topic-metadata">

**Author:** [@AlexLarrieu](https://community.dynatrace.com/u/AlexLarrieu)\
**Replies:** 6\
**Last updated:** [June 10, 2026, 8:41am UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975 "2026-06-10T08:41:10Z")

</div>

Hello, Using DQL, I want to create a graph to display the number of requests for a specific service with a response time \> 10s. Similar to the Distributed Tracing app ( but not only Successful requests ). Could you he…

---

## [Gen3 Dashboard Variables - Display label different from value in Query-type variables](https://community.dynatrace.com/t/gen3-dashboard-variables-display-label-different-from-value-in-query-type-variables/56004)

<div class="topic-metadata">

**Author:** [@VictorRuiz](https://community.dynatrace.com/u/VictorRuiz)\
**Replies:** 1\
**Last updated:** [June 9, 2026, 1:08am UTC](https://community.dynatrace.com/t/gen3-dashboard-variables-display-label-different-from-value-in-query-type-variables/56004 "2026-06-09T01:08:08Z")

</div>

Hi Community, I’m working with Gen3 Dashboards and I’m facing a challenge with Query-type variables where I need to: Display a human-readable name to the user (e.g. SERVICE-BPM-Procesar) Use the entity ID in tile quer…

---

## [PARSING INTO JSON\_ARRAY - Different behavior between openpipeline and notebook](https://community.dynatrace.com/t/parsing-into-json-array-different-behavior-between-openpipeline-and-notebook/56113)

<div class="topic-metadata">

**Author:** [@FredSelvaGen](https://community.dynatrace.com/u/FredSelvaGen)\
**Replies:** 0\
**Last updated:** [June 8, 2026, 10:13am UTC](https://community.dynatrace.com/t/parsing-into-json-array-different-behavior-between-openpipeline-and-notebook/56113 "2026-06-08T10:13:38Z")

</div>

Hello community, I’m looking for help regarding bizevent processing in openpipeline. It looks like that PARSE (into JSON\_ARRAY) dql command doesn’t have the same behavior between Openpipeline and Notebook Data input …

---

## [Parsing URL to extract data](https://community.dynatrace.com/t/parsing-url-to-extract-data/56050)

<div class="topic-metadata">

**Author:** [@apourbaix](https://community.dynatrace.com/u/apourbaix)\
**Replies:** 2\
**Last updated:** [June 1, 2026, 2:14pm UTC](https://community.dynatrace.com/t/parsing-url-to-extract-data/56050 "2026-06-01T14:14:53Z")

</div>

In DQL, I’m trying to parse an url to extract usefull data. Example: https://api-services.unknown.com/env/v6/permissions/check I want to extract api version which is v6 in this case. Then, I want all the following, whi…

---

## [Recreating Native Problem Chart Behavior in DQL (Active Problems Over Time)](https://community.dynatrace.com/t/recreating-native-problem-chart-behavior-in-dql-active-problems-over-time/56034)

<div class="topic-metadata">

**Author:** [@zaidanrizq](https://community.dynatrace.com/u/zaidanrizq)\
**Replies:** 3\
**Last updated:** [May 29, 2026, 9:01am UTC](https://community.dynatrace.com/t/recreating-native-problem-chart-behavior-in-dql-active-problems-over-time/56034 "2026-05-29T09:01:26Z")

</div>

Hi everyone, I’m trying to recreate the problem chart from the Problems menu using DQL, but I’m struggling to match the behavior of the native visualization. Current approach: fetch dt.davis.problems | makeTimeseries …

---

## [How to display multiple proxy metadata entries in tabular format instead of a single JSON cell](https://community.dynatrace.com/t/how-to-display-multiple-proxy-metadata-entries-in-tabular-format-instead-of-a-single-json-cell/56013)

<div class="topic-metadata">

**Author:** [@achoud22](https://community.dynatrace.com/u/achoud22)\
**Replies:** 1\
**Last updated:** [May 27, 2026, 2:00pm UTC](https://community.dynatrace.com/t/how-to-display-multiple-proxy-metadata-entries-in-tabular-format-instead-of-a-single-json-cell/56013 "2026-05-27T14:00:55Z")

</div>

We are currently fetching proxy metadata using an external service and persisting the output as a business event. To reduce the number of biz events, we ingest metadata for all proxies (e.g., 9 proxies) as a single JSON …

---

## [Process availability Grail - Anomaly Detector](https://community.dynatrace.com/t/process-availability-grail-anomaly-detector/55981)

<div class="topic-metadata">

**Author:** [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Replies:** 0\
**Last updated:** [May 21, 2026, 2:01pm UTC](https://community.dynatrace.com/t/process-availability-grail-anomaly-detector/55981 "2026-05-21T14:01:46Z")

</div>

Hi, I am coming here from this product idea. Main issue is how to adding a delay when process is not running before Davis creates a problem. It means, something similar as you can do using OS Services. Since Anomaly d…

---

## [Transform timezone with DQL](https://community.dynatrace.com/t/transform-timezone-with-dql/55614)

<div class="topic-metadata">

**Author:** [@elenaperez](https://community.dynatrace.com/u/elenaperez)\
**Replies:** 2\
**Last updated:** [May 20, 2026, 8:00am UTC](https://community.dynatrace.com/t/transform-timezone-with-dql/55614 "2026-05-20T08:00:08Z")

</div>

Hi team We have noticed that the dt.system.events are ingested with a different time zone. Is it possible to transform the timezone with DQL here? I tried using bin(timestamp,24h,at:-1h), but with the change of hour…

---

## [Store the moment a value changes in a field](https://community.dynatrace.com/t/store-the-moment-a-value-changes-in-a-field/55793)

<div class="topic-metadata">

**Author:** [@Red](https://community.dynatrace.com/u/Red)\
**Replies:** 1\
**Last updated:** [May 20, 2026, 7:41am UTC](https://community.dynatrace.com/t/store-the-moment-a-value-changes-in-a-field/55793 "2026-05-20T07:41:48Z")

</div>

Hello community, I’m trying to do something with DQL, but I’m not even sure it’s possible. To give you some context, I have a DQL query to display Control-M jobs that are retrieved using the following extension: timese…

---

## [Davis AI Predictive Analyzer Use Cases](https://community.dynatrace.com/t/davis-ai-predictive-analyzer-use-cases/55952)

<div class="topic-metadata">

**Author:** [@saldrich](https://community.dynatrace.com/u/saldrich)\
**Replies:** 0\
**Last updated:** [May 19, 2026, 4:48pm UTC](https://community.dynatrace.com/t/davis-ai-predictive-analyzer-use-cases/55952 "2026-05-19T16:48:57Z")

</div>

Currently we have a few workflows for CPU, Memory and Disk Space for Davis AI Predictive Analyzer. (capacity management) Are there any other use cases folks have created notebooks with DQL queries for this? I heard you …

---

## [Error when running DQL Query through workflow](https://community.dynatrace.com/t/error-when-running-dql-query-through-workflow/41717)

<div class="topic-metadata">

**Author:** [@CameronFW](https://community.dynatrace.com/u/CameronFW)\
**Replies:** 2\
**Last updated:** [May 19, 2026, 2:35pm UTC](https://community.dynatrace.com/t/error-when-running-dql-query-through-workflow/41717 "2026-05-19T14:35:11Z")

</div>

An error occurred: HTTP Error 431: Request Header Fields Too Large Query (on a 30m timer): fetch logs, from:now() - 30m| filter matchesPhrase(content, “\[LATEFILE\]”) and status == “WARN”| fields latefile, {host.name, al…

---

## [Use DQL query within Problem trigger to Teams Workflow](https://community.dynatrace.com/t/use-dql-query-within-problem-trigger-to-teams-workflow/55926)

<div class="topic-metadata">

**Author:** [@Hillman](https://community.dynatrace.com/u/Hillman)\
**Replies:** 2\
**Last updated:** [May 19, 2026, 3:10am UTC](https://community.dynatrace.com/t/use-dql-query-within-problem-trigger-to-teams-workflow/55926 "2026-05-19T03:10:16Z")

</div>

As the mobile app will soon be end-of-support, I am now testing the workflow that send notification to Teams whenever there are problems being triggered. However, I do not want to send every problem alerts to Teams. Onl…

---

## [Conditional alerting on Anomaly Detector](https://community.dynatrace.com/t/conditional-alerting-on-anomaly-detector/55909)

<div class="topic-metadata">

**Author:** [@g\_kat](https://community.dynatrace.com/u/g_kat)\
**Replies:** 3\
**Last updated:** [May 14, 2026, 12:53pm UTC](https://community.dynatrace.com/t/conditional-alerting-on-anomaly-detector/55909 "2026-05-14T12:53:34Z")

</div>

Hi, I have been trying to create the following Anomaly Detector configuration: evaluate the average dt.host.cpu.usage for a host group and alert if it’s above 80%. The tricky part is that I want to generate a conditio…

---

## [Data from csv including comma](https://community.dynatrace.com/t/data-from-csv-including-comma/55903)

<div class="topic-metadata">

**Author:** [@loopy](https://community.dynatrace.com/u/loopy)\
**Replies:** 1\
**Last updated:** [May 14, 2026, 9:55am UTC](https://community.dynatrace.com/t/data-from-csv-including-comma/55903 "2026-05-14T09:55:37Z")

</div>

Data is currently in a string from a csv for example 2026-05-13 22:51:49.585,email@email.com,service,com.corp.ag,DENIED,“designer, app-user” Need to parse it so the data is in format: | timestamp …

---

## [Can we import text and excel file in Dynatrace query](https://community.dynatrace.com/t/can-we-import-text-and-excel-file-in-dynatrace-query/55878)

<div class="topic-metadata">

**Author:** [@kumarv14](https://community.dynatrace.com/u/kumarv14)\
**Replies:** 3\
**Last updated:** [May 12, 2026, 9:52am UTC](https://community.dynatrace.com/t/can-we-import-text-and-excel-file-in-dynatrace-query/55878 "2026-05-12T09:52:39Z")

</div>

Hello all/ @krzysztof\_hoja Could you please advise on how to import a TXT or XLS file into Dynatrace so that it can be used within a query? Specifically, I would like to read IMSI values from the file and use them dynam…

---

## [Resolve DQL Error When Query Returns Multiple Metrics](https://community.dynatrace.com/t/resolve-dql-error-when-query-returns-multiple-metrics/49148)

<div class="topic-metadata">

**Author:** [@nilkanthj](https://community.dynatrace.com/u/nilkanthj)\
**Replies:** 3\
**Last updated:** [May 7, 2026, 8:33am UTC](https://community.dynatrace.com/t/resolve-dql-error-when-query-returns-multiple-metrics/49148 "2026-05-07T08:33:20Z")

</div>

created below DQL to monitor the Disk with used.percent and disk.avail condition however we are getting below error message. Could you please help to fix this issue ? DQL timeseries { averageDiskU = avg(dt.host.disk.u…

---

## [Calculate a succes rate line with metrics](https://community.dynatrace.com/t/calculate-a-succes-rate-line-with-metrics/55821)

<div class="topic-metadata">

**Author:** [@enrico\_afkl](https://community.dynatrace.com/u/enrico_afkl)\
**Replies:** 2\
**Last updated:** [May 7, 2026, 6:46am UTC](https://community.dynatrace.com/t/calculate-a-succes-rate-line-with-metrics/55821 "2026-05-07T06:46:06Z")

</div>

Hello, I’d like to calculate a ratio between totalCalls and successCalls using a metric “log.prgoffer.foapi.baminfo.golden.exceptions”. timeseries totalCalls=sum(log.prgoffer.foapi.baminfo.golden.exceptions), interval…

---

## [Limitations of Segments DQL Like Filter](https://community.dynatrace.com/t/limitations-of-segments-dql-like-filter/55792)

<div class="topic-metadata">

**Author:** [@MarwanC](https://community.dynatrace.com/u/MarwanC)\
**Replies:** 1\
**Last updated:** [May 5, 2026, 8:29am UTC](https://community.dynatrace.com/t/limitations-of-segments-dql-like-filter/55792 "2026-05-05T08:29:45Z")

</div>

One of the most frustrating parts in segments is limiting the way we use the DQL like filter in the segment definition, we developed in our organisation the concept of super segments where we combine a number of segments…

---

## [Calculation of Percentage of problems with "Summarize" in DQL](https://community.dynatrace.com/t/calculation-of-percentage-of-problems-with-summarize-in-dql/46382)

<div class="topic-metadata">

**Author:** [@JhonU](https://community.dynatrace.com/u/JhonU)\
**Replies:** 3\
**Last updated:** [May 4, 2026, 11:58am UTC](https://community.dynatrace.com/t/calculation-of-percentage-of-problems-with-summarize-in-dql/46382 "2026-05-04T11:58:48Z")

</div>

Hello, maybe you could help me, I have a query that counts the total events by category “event.category”, when using the summarize command I cannot calculate the total events in this way to obtain the percentage it repre…

---

## [Anomaly Detector - Disk monitoring AND condition](https://community.dynatrace.com/t/anomaly-detector-disk-monitoring-and-condition/55676)

<div class="topic-metadata">

**Author:** [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Replies:** 4\
**Last updated:** [May 4, 2026, 10:44am UTC](https://community.dynatrace.com/t/anomaly-detector-disk-monitoring-and-condition/55676 "2026-05-04T10:44:55Z")

</div>

Hi, I would like to create an Anomaly Detector rule to create a disk problem when two conditions being matched. It is important AND condition is done, not OR: Idea would be checking 2 timeseries data to match those 2 c…

---

## [I built a little playground for DQL — come break it](https://community.dynatrace.com/t/i-built-a-little-playground-for-dql-come-break-it/55778)

<div class="topic-metadata">

**Author:** [@Maheedhar\_T](https://community.dynatrace.com/u/Maheedhar_T)\
**Replies:** 0\
**Last updated:** [May 1, 2026, 10:41am UTC](https://community.dynatrace.com/t/i-built-a-little-playground-for-dql-come-break-it/55778 "2026-05-01T10:41:55Z")

</div>

Hi everyone! Like many of you, I’ve been spending a fair bit of my own time in the Dynatrace ecosystem — and one thing I keep running into, both for myself and watching others in the community, is that DQL trips people …

---

## [Joining Grail metrics with BizEvents metadata in a single DQL table](https://community.dynatrace.com/t/joining-grail-metrics-with-bizevents-metadata-in-a-single-dql-table/55734)

<div class="topic-metadata">

**Author:** [@achoud22](https://community.dynatrace.com/u/achoud22)\
**Replies:** 1\
**Last updated:** [April 29, 2026, 8:56pm UTC](https://community.dynatrace.com/t/joining-grail-metrics-with-bizevents-metadata-in-a-single-dql-table/55734 "2026-04-29T20:56:13Z")

</div>

I’m working on a use case where all proxy metadata is ingested as BizEvents and displayed in a table. In addition, I’ve defined a derived variable ProxyStatus that toggles between Active and Inactive depending on the req…

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

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