# DQL

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

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

**Page:** 7

---

## [Count Consecutive Minutes a Metric Exceeds Threshold Using DQL](https://community.dynatrace.com/t/count-consecutive-minutes-a-metric-exceeds-threshold-using-dql/51731)

<div class="topic-metadata">

**Author:** [@Omerre](https://community.dynatrace.com/u/Omerre)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 10:45am UTC](https://community.dynatrace.com/t/count-consecutive-minutes-a-metric-exceeds-threshold-using-dql/51731 "2025-12-18T10:45:36Z")

</div>

Hey all, I need to create an alert when a certain metric\* is above a threshold for more than 2 hours. Since the maximum length of the Anomaly Detection sliding window is 60 minutes, I thought of this workaround: creati…

---

## [Fix Null Output Issues When Parsing Data with DQL](https://community.dynatrace.com/t/fix-null-output-issues-when-parsing-data-with-dql/51877)

<div class="topic-metadata">

**Author:** [@sharmas2](https://community.dynatrace.com/u/sharmas2)\
**Replies:** 5\
**Last updated:** [December 18, 2025, 10:44am UTC](https://community.dynatrace.com/t/fix-null-output-issues-when-parsing-data-with-dql/51877 "2025-12-18T10:44:02Z")

</div>

Hi, “I have the following Splunk query, and I’m trying to generate the corresponding output in Dynatrace.” splunk query :- index=ngss\*\_sourcefire\_secevents | rex field=index “(?\<Local\_Market\>\\w.\*?)\_” | eval BlockedSt…

---

## [Fetch Request Counts Based on Conditions Using DQL](https://community.dynatrace.com/t/fetch-request-counts-based-on-conditions-using-dql/51988)

<div class="topic-metadata">

**Author:** [@Shibra](https://community.dynatrace.com/u/Shibra)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 10:41am UTC](https://community.dynatrace.com/t/fetch-request-counts-based-on-conditions-using-dql/51988 "2025-12-18T10:41:41Z")

</div>

Hi Dynatrace Community, I’m trying to build a metric selector query that fetches the request count for requests where the response time falls within a specific range (e.g., between 200ms and 500ms). Has anyone implemen…

---

## [Use DQL Search Command for Efficient Data Retrieval](https://community.dynatrace.com/t/use-dql-search-command-for-efficient-data-retrieval/52240)

<div class="topic-metadata">

**Author:** [@m\_zol](https://community.dynatrace.com/u/m_zol)\
**Replies:** 4\
**Last updated:** [December 18, 2025, 10:39am UTC](https://community.dynatrace.com/t/use-dql-search-command-for-efficient-data-retrieval/52240 "2025-12-18T10:39:56Z")

</div>

Hello, Is it possible to use the search command in DQL to mask or obfuscate certain information based on a pattern? For example, I’d like to search logs that contain a credit card number and then mask part of it (e.g.,…

---

## [Count Hosts by Custom Metadata or Tags Using DQL](https://community.dynatrace.com/t/count-hosts-by-custom-metadata-or-tags-using-dql/52338)

<div class="topic-metadata">

**Author:** [@Peter\_Youssef](https://community.dynatrace.com/u/Peter_Youssef)\
**Replies:** 5\
**Last updated:** [December 18, 2025, 10:37am UTC](https://community.dynatrace.com/t/count-hosts-by-custom-metadata-or-tags-using-dql/52338 "2025-12-18T10:37:05Z")

</div>

Dear community members, I need a custom DQL queries for fetching hosts via custom host metadata or Tags. If there are practical use cases that would be appreciated. BR, Peter

---

## [Add Average Host Availability to Tables Using DQL](https://community.dynatrace.com/t/add-average-host-availability-to-tables-using-dql/52417)

<div class="topic-metadata">

**Author:** [@apichatpunkaewq](https://community.dynatrace.com/u/apichatpunkaewq)\
**Replies:** 2\
**Last updated:** [December 18, 2025, 10:32am UTC](https://community.dynatrace.com/t/add-average-host-availability-to-tables-using-dql/52417 "2025-12-18T10:32:22Z")

</div>

I would like to add the host availability metric to the attached table to display CPU, memory, and disk performance, as well as availability.

---

## [Filter Appended Time-Series by Tag Value Using DQL](https://community.dynatrace.com/t/filter-appended-time-series-by-tag-value-using-dql/54290)

<div class="topic-metadata">

**Author:** [@markj](https://community.dynatrace.com/u/markj)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 10:26am UTC](https://community.dynatrace.com/t/filter-appended-time-series-by-tag-value-using-dql/54290 "2025-12-18T10:26:29Z")

</div>

I’ve been exploring DQL and trying to get a timeseries query working. It would be easier to query based on hard names but that’s too easy. The general idea is that I’m filtering for a message queue with a key value tag s…

---

## [Need alternative to spread in DQL to avoid value distribution across the entire timeframe](https://community.dynatrace.com/t/need-alternative-to-spread-in-dql-to-avoid-value-distribution-across-the-entire-timeframe/54425)

<div class="topic-metadata">

**Author:** [@jeffrey\_valerio](https://community.dynatrace.com/u/jeffrey_valerio)\
**Replies:** 0\
**Last updated:** [December 17, 2025, 7:19pm UTC](https://community.dynatrace.com/t/need-alternative-to-spread-in-dql-to-avoid-value-distribution-across-the-entire-timeframe/54425 "2025-12-17T19:19:01Z")

</div>

Hello, I need to know if it’s possible to use DQL to maintain some kind of counter. My goal is to detect a condition only when the alert has occurred at least twice, so that a problem is raised only when it reaches that…

---

## [Fetch Cluster ID and Name in Metrics Queries Using DQL](https://community.dynatrace.com/t/fetch-cluster-id-and-name-in-metrics-queries-using-dql/52590)

<div class="topic-metadata">

**Author:** [@manuanand](https://community.dynatrace.com/u/manuanand)\
**Replies:** 4\
**Last updated:** [December 17, 2025, 2:11pm UTC](https://community.dynatrace.com/t/fetch-cluster-id-and-name-in-metrics-queries-using-dql/52590 "2025-12-17T14:11:14Z")

</div>

Hi all, I am creating a Dynatrace dashboard for which I need data from a particular cluster, I am currently using AWS Container Insight metrics in Dynatrace data explorer, specifically metrics like: ext:cloud.aws.conta…

---

## [Query Maximum RabbitMQ Message Count Using DQL](https://community.dynatrace.com/t/query-maximum-rabbitmq-message-count-using-dql/52524)

<div class="topic-metadata">

**Author:** [@simonwu42195](https://community.dynatrace.com/u/simonwu42195)\
**Replies:** 3\
**Last updated:** [December 17, 2025, 1:47pm UTC](https://community.dynatrace.com/t/query-maximum-rabbitmq-message-count-using-dql/52524 "2025-12-17T13:47:04Z")

</div>

Currently we have a DQL query running in workflow for checking the max value of one of the rabbitmq queues from 22:00 to 23:59 and send us alert if the max value is lower than the threshold. The workflow running in the m…

---

## [Configure Multi-Select Dashboard Variables That Populate Other Fields](https://community.dynatrace.com/t/configure-multi-select-dashboard-variables-that-populate-other-fields/52838)

<div class="topic-metadata">

**Author:** [@Edjumacator](https://community.dynatrace.com/u/Edjumacator)\
**Replies:** 6\
**Last updated:** [December 17, 2025, 1:40pm UTC](https://community.dynatrace.com/t/configure-multi-select-dashboard-variables-that-populate-other-fields/52838 "2025-12-17T13:40:55Z")

</div>

I have two multi-select variables, “Scope” which contains values used in dt.entity.host names and then “Hosts” which I would like to filter based on selected “Scope” values. Scope: Hosts: My goal would be to gat…

---

## [Use DPL Pattern Expression Macros for Efficient Data Processing](https://community.dynatrace.com/t/use-dpl-pattern-expression-macros-for-efficient-data-processing/52886)

<div class="topic-metadata">

**Author:** [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Replies:** 3\
**Last updated:** [December 17, 2025, 1:39pm UTC](https://community.dynatrace.com/t/use-dpl-pattern-expression-macros-for-efficient-data-processing/52886 "2025-12-17T13:39:38Z")

</div>

Hello folks, I’ve recently come across the concept of creating pattern expressions as macros in Dynatrace Pattern Language (DPL). However, I would like to understand this feature a bit more deeply. Could someone please …

---

## [Process a line with multiple Services\\Status \\n](https://community.dynatrace.com/t/process-a-line-with-multiple-services-status-n/53554)

<div class="topic-metadata">

**Author:** [@CTull](https://community.dynatrace.com/u/CTull)\
**Replies:** 2\
**Last updated:** [December 17, 2025, 1:11pm UTC](https://community.dynatrace.com/t/process-a-line-with-multiple-services-status-n/53554 "2025-12-17T13:11:50Z")

</div>

I have something similar to pull in for a health check on services. Example JSON. { “event.type”: “LOG”, “content”: “Last Modified at: ,2025-08-29 08:25:03.747519\\nservice1,Good\\nservice2,Good\\nservice3,Good\\nservice…

---

## [Count Running and Stopped Services Using DQL Queries (Dynatrace 3rd gen)](https://community.dynatrace.com/t/count-running-and-stopped-services-using-dql-queries-dynatrace-3rd-gen/53174)

<div class="topic-metadata">

**Author:** [@donaannie1](https://community.dynatrace.com/u/donaannie1)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 1:08pm UTC](https://community.dynatrace.com/t/count-running-and-stopped-services-using-dql-queries-dynatrace-3rd-gen/53174 "2025-12-17T13:08:40Z")

</div>

I need the count of running services and stopped services against each management zones in dynatrace dashboard(gen3). Below dql is not working fetch dt.entity.os\_service, dt.entity.host | lookup dt.entity.host, from: r…

---

## [Query Problem Events Related to Service Methods Using DQL](https://community.dynatrace.com/t/query-problem-events-related-to-service-methods-using-dql/48735)

<div class="topic-metadata">

**Author:** [@RPbiaggio](https://community.dynatrace.com/u/RPbiaggio)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 12:11pm UTC](https://community.dynatrace.com/t/query-problem-events-related-to-service-methods-using-dql/48735 "2025-12-17T12:11:23Z")

</div>

Guys, does anyone know if it is possible with DQL to see what service method is related to the problem? I need to view how the impacted entity or root causes the service method. Today, I can only see the service, workloa…

---

## [Convert JSON Objects to DOUBLE or IPADDR Types Using DPL Rules](https://community.dynatrace.com/t/convert-json-objects-to-double-or-ipaddr-types-using-dpl-rules/48810)

<div class="topic-metadata">

**Author:** [@mosharref\_hossn](https://community.dynatrace.com/u/mosharref_hossn)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 12:10pm UTC](https://community.dynatrace.com/t/convert-json-objects-to-double-or-ipaddr-types-using-dpl-rules/48810 "2025-12-17T12:10:29Z")

</div>

I have a log processing rule to capture the HTTP request header data. I want the data type to be DOUBLE for request size values and IPADDR for IPs. However, the data always gets parsed as STRING data type. Any options…

---

## [Apply OpenPipeline DQL Data Masking Rules Across All Attributes](https://community.dynatrace.com/t/apply-openpipeline-dql-data-masking-rules-across-all-attributes/49134)

<div class="topic-metadata">

**Author:** [@bobmacks](https://community.dynatrace.com/u/bobmacks)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 12:09pm UTC](https://community.dynatrace.com/t/apply-openpipeline-dql-data-masking-rules-across-all-attributes/49134 "2025-12-17T12:09:32Z")

</div>

Hi, We use DQL rules for cardholder data masking in Open Pipeline through combinations of string functions - replacePatterns, replaceString - similar to the snippet below fieldsAdd a = replacePattern(content, \<\<Masing …

---

## [Count Pods per Availability Zone in GCP Using DQL Queries](https://community.dynatrace.com/t/count-pods-per-availability-zone-in-gcp-using-dql-queries/51904)

<div class="topic-metadata">

**Author:** [@kalyani\_s](https://community.dynatrace.com/u/kalyani_s)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 12:02pm UTC](https://community.dynatrace.com/t/count-pods-per-availability-zone-in-gcp-using-dql-queries/51904 "2025-12-17T12:02:29Z")

</div>

I am looking to get the pod count per availability zone in GCP. I am unable to see the spit by zone option when trying to get the pods. Is there a way to achieve this?

---

## [Compare Output Values Between Splunk and Dynatrace Using DQL](https://community.dynatrace.com/t/compare-output-values-between-splunk-and-dynatrace-using-dql/51911)

<div class="topic-metadata">

**Author:** [@sharmas2](https://community.dynatrace.com/u/sharmas2)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 12:01pm UTC](https://community.dynatrace.com/t/compare-output-values-between-splunk-and-dynatrace-using-dql/51911 "2025-12-17T12:01:32Z")

</div>

Hi, “I have the following Splunk query, and I’m trying to generate the corresponding output in Dynatrace.” splunk query :- index=ngss\*\_sourcefire\_secevents | rex field=index “(?\<Local\_Market\>\\w.\*?)\_” | eval BlockedSt…

---

## [Change All Key Names in Data Sets Using DQL or DPL Queries](https://community.dynatrace.com/t/change-all-key-names-in-data-sets-using-dql-or-dpl-queries/53544)

<div class="topic-metadata">

**Author:** [@36Krazyfists](https://community.dynatrace.com/u/36Krazyfists)\
**Replies:** 2\
**Last updated:** [December 17, 2025, 11:16am UTC](https://community.dynatrace.com/t/change-all-key-names-in-data-sets-using-dql-or-dpl-queries/53544 "2025-12-17T11:16:50Z")

</div>

I’ve already got a K/V DPL that is extracting some data from a field into a JSON object where I will then dynamically parse the data into their own separate fields. However, before I parse them into their own fields, I’…

---

## [Display AWS EBS Volumes Near Maximum IOPS Using DQL](https://community.dynatrace.com/t/display-aws-ebs-volumes-near-maximum-iops-using-dql/52419)

<div class="topic-metadata">

**Author:** [@mark\_linders](https://community.dynatrace.com/u/mark_linders)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:27am UTC](https://community.dynatrace.com/t/display-aws-ebs-volumes-near-maximum-iops-using-dql/52419 "2025-12-17T10:27:50Z")

</div>

I was using DQL to create a visualization that displays my EBS volumes and shows how close they are to hitting their maximum IOPS, or list if they are already under high usage. I did something like this: timeseries by:…

---

## [Use Dynatrace DQL for Advanced Querying and Data Analysis](https://community.dynatrace.com/t/use-dynatrace-dql-for-advanced-querying-and-data-analysis/52446)

<div class="topic-metadata">

**Author:** [@Sachindthug](https://community.dynatrace.com/u/Sachindthug)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:26am UTC](https://community.dynatrace.com/t/use-dynatrace-dql-for-advanced-querying-and-data-analysis/52446 "2025-12-17T10:26:54Z")

</div>

Below is my question and wanted to know what would be the DQL query for this? Fetch all the Kubernetes nodes/Pods Filter Nodes having namespace easytrade Fetch average CPU of all the pods. Fetch 95 percentile of all th…

---

## [Remove Duplicate Entries in Custom Metric Data Using DQL](https://community.dynatrace.com/t/remove-duplicate-entries-in-custom-metric-data-using-dql/52726)

<div class="topic-metadata">

**Author:** [@knallapa](https://community.dynatrace.com/u/knallapa)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:26am UTC](https://community.dynatrace.com/t/remove-duplicate-entries-in-custom-metric-data-using-dql/52726 "2025-12-17T10:26:30Z")

</div>

How can I eliminate duplications in DQL when working with timeseries custom metric data filtered by conditions? USECASE: Loading Custom metrics in below query 10 times in timeseries is killing DQL Storage bucket. I atte…

---

## [Populate applications list with the list of services and endpoints](https://community.dynatrace.com/t/populate-applications-list-with-the-list-of-services-and-endpoints/53250)

<div class="topic-metadata">

**Author:** [@Pavan1](https://community.dynatrace.com/u/Pavan1)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:22am UTC](https://community.dynatrace.com/t/populate-applications-list-with-the-list-of-services-and-endpoints/53250 "2025-12-17T10:22:49Z")

</div>

Please let me know how to download the applications list with all its services, endpoints. I can see that in “called services” in the application but those are not exhaustive. Also, when trying to run the below DQL, lis…

---

## [Query Cost Allocation for Short-Lived Environments Using DQL](https://community.dynatrace.com/t/query-cost-allocation-for-short-lived-environments-using-dql/53791)

<div class="topic-metadata">

**Author:** [@ftmazzone](https://community.dynatrace.com/u/ftmazzone)\
**Replies:** 2\
**Last updated:** [December 17, 2025, 10:15am UTC](https://community.dynatrace.com/t/query-cost-allocation-for-short-lived-environments-using-dql/53791 "2025-12-17T10:15:18Z")

</div>

Hello, For our short-lived environments and servers, we would like to use the cost allocation feature and provide to standard users an option to view the consumption per cost center. The cost center in our case is uniqu…

---

## [Use DQL Processor for Metrics Transformation and Analysis](https://community.dynatrace.com/t/use-dql-processor-for-metrics-transformation-and-analysis/53428)

<div class="topic-metadata">

**Author:** [@36Krazyfists](https://community.dynatrace.com/u/36Krazyfists)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:13am UTC](https://community.dynatrace.com/t/use-dql-processor-for-metrics-transformation-and-analysis/53428 "2025-12-17T10:13:22Z")

</div>

Now, I’m not talking about extracting metrics from a log or an event. I know how to do that very well. What I’m talking about is, in OpenPipeline, you can create pipelines for Metrics where you can apply processors to …

---

## [Add Timestamp and Schema to Statement Performance Data Using DQL (Oracle Database Monitoring Extension)](https://community.dynatrace.com/t/add-timestamp-and-schema-to-statement-performance-data-using-dql-oracle-database-monitoring-extension/53801)

<div class="topic-metadata">

**Author:** [@badgerfifteen](https://community.dynatrace.com/u/badgerfifteen)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:08am UTC](https://community.dynatrace.com/t/add-timestamp-and-schema-to-statement-performance-data-using-dql-oracle-database-monitoring-extension/53801 "2025-12-17T10:08:41Z")

</div>

Hi all, This is regarding the Statement Performance section in the ‘Databases’ section (Applicable to Oracle Database Monitoring extension only). In this section, when you click ‘Pin to Dashboard’ this code is produced…

---

## [Dynamic Filter for entity tags for fetching related problems](https://community.dynatrace.com/t/dynamic-filter-for-entity-tags-for-fetching-related-problems/53824)

<div class="topic-metadata">

**Author:** [@karthikayini\_m](https://community.dynatrace.com/u/karthikayini_m)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:07am UTC](https://community.dynatrace.com/t/dynamic-filter-for-entity-tags-for-fetching-related-problems/53824 "2025-12-17T10:07:41Z")

</div>

Hi All, requirement: need to filter the problems for entity tags . here entity tags are nothing but a assignmentgroup name which are tagged for each application. So each application owner should be able to filter using …

---

## [Davis alert for interface count changes per device (7-day comparison)](https://community.dynatrace.com/t/davis-alert-for-interface-count-changes-per-device-7-day-comparison/53864)

<div class="topic-metadata">

**Author:** [@RaidanAlmaqtari](https://community.dynatrace.com/u/RaidanAlmaqtari)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:04am UTC](https://community.dynatrace.com/t/davis-alert-for-interface-count-changes-per-device-7-day-comparison/53864 "2025-12-17T10:04:29Z")

</div>

Hi everyone, I’d like to create a Davis anomaly detection (DQL event) that triggers when the number of interfaces (ports) on a network device changes between two time periods (e.g., previous 7 days vs current 7 days). M…

---

## [How to filter a timeseries based on a value?](https://community.dynatrace.com/t/how-to-filter-a-timeseries-based-on-a-value/53876)

<div class="topic-metadata">

**Author:** [@badgerfifteen](https://community.dynatrace.com/u/badgerfifteen)\
**Replies:** 1\
**Last updated:** [December 17, 2025, 10:04am UTC](https://community.dynatrace.com/t/how-to-filter-a-timeseries-based-on-a-value/53876 "2025-12-17T10:04:06Z")

</div>

Hi, I am in the process of creating a dashboard where it shows the synthetic availability of all our synthetics in our environment. We have a diverse amount of synthetics which run from 5 mins to 10mins and what I am t…

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

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