# DQL

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

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

**Page:** 5

---

## [Timeseries regression - trend line](https://community.dynatrace.com/t/timeseries-regression-trend-line/54845)

<div class="topic-metadata">

**Author:** [@J01am](https://community.dynatrace.com/u/J01am)\
**Replies:** 0\
**Last updated:** [February 2, 2026, 5:37pm UTC](https://community.dynatrace.com/t/timeseries-regression-trend-line/54845 "2026-02-02T17:37:47Z")

</div>

Hi all, I needed to display the trend of a time series using a mathematical regression. Since DQL doesn’t provide an out-of-the-box function for this today, I implemented it with the following DQL query. timeseries y=a…

---

## [Get percentage of time with ACTIVE problems and not](https://community.dynatrace.com/t/get-percentage-of-time-with-active-problems-and-not/54818)

<div class="topic-metadata">

**Author:** [@tarjei](https://community.dynatrace.com/u/tarjei)\
**Replies:** 0\
**Last updated:** [January 30, 2026, 11:42am UTC](https://community.dynatrace.com/t/get-percentage-of-time-with-active-problems-and-not/54818 "2026-01-30T11:42:32Z")

</div>

Hi! We would like to create a query which checks a timeperiod for all “timebuckets” where a problem was open. fetch events | filter event.kind == "DAVIS\_PROBLEM" | filter event.category == "AVAILABILITY" | filter event…

---

## [Result in Percentage of service in a single query](https://community.dynatrace.com/t/result-in-percentage-of-service-in-a-single-query/54657)

<div class="topic-metadata">

**Author:** [@kumarv14](https://community.dynatrace.com/u/kumarv14)\
**Replies:** 3\
**Last updated:** [January 30, 2026, 11:08am UTC](https://community.dynatrace.com/t/result-in-percentage-of-service-in-a-single-query/54657 "2026-01-30T11:08:38Z")

</div>

i wants to check % of success and failure in my query these are (0",“1”,“200”,“1001”,“2001”,“5001”,“5450”)success code rest are all error code , so how can i get % of service in succes and failure respectively . with th…

---

## [storage size by logsource](https://community.dynatrace.com/t/storage-size-by-logsource/54808)

<div class="topic-metadata">

**Author:** [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Replies:** 0\
**Last updated:** [January 29, 2026, 4:17pm UTC](https://community.dynatrace.com/t/storage-size-by-logsource/54808 "2026-01-29T16:17:05Z")

</div>

I am trying to get the raw storage data for log source. however, this query is not returning the rawsize correctly, any help is appreciated. fetch logs | summarize count(), sum(rawsize), by:\`log.source\` | sort \`sum(ra…

---

## [Show a top 20 list of servers that consume the most disk space](https://community.dynatrace.com/t/show-a-top-20-list-of-servers-that-consume-the-most-disk-space/54315)

<div class="topic-metadata">

**Author:** [@MillerGEP](https://community.dynatrace.com/u/MillerGEP)\
**Replies:** 6\
**Last updated:** [January 29, 2026, 3:57pm UTC](https://community.dynatrace.com/t/show-a-top-20-list-of-servers-that-consume-the-most-disk-space/54315 "2026-01-29T15:57:38Z")

</div>

Hi Everyone. I’m trying to create a dashboard with a top 20 list of servers that consume the most disk space. I’m using this DQL, but it’s not working. I think it’s because I don’t have the dt.host.disk.total metric. So,…

---

## [How to get data about queries from old/classic dynatrace screens ?](https://community.dynatrace.com/t/how-to-get-data-about-queries-from-old-classic-dynatrace-screens/54684)

<div class="topic-metadata">

**Author:** [@josef\_solnicky](https://community.dynatrace.com/u/josef_solnicky)\
**Replies:** 3\
**Last updated:** [January 28, 2026, 12:46pm UTC](https://community.dynatrace.com/t/how-to-get-data-about-queries-from-old-classic-dynatrace-screens/54684 "2026-01-28T12:46:13Z")

</div>

When investigating dashboard(s) usage - I created also dashboard about user activity inside SaaS environment. The source is “fetch dt.system.query\_executions”. Now I got idea to display also “SaaS adoption tile” - mea…

---

## [Give a service, find if calling service having problem](https://community.dynatrace.com/t/give-a-service-find-if-calling-service-having-problem/54613)

<div class="topic-metadata">

**Author:** [@PVThach](https://community.dynatrace.com/u/PVThach)\
**Replies:** 1\
**Last updated:** [January 28, 2026, 12:17pm UTC](https://community.dynatrace.com/t/give-a-service-find-if-calling-service-having-problem/54613 "2026-01-28T12:17:52Z")

</div>

I’m looking for guidance on creating a DQL query for as dashboard that can: Take a given list of services. Identify their associated upstream and downstream dependencies. Display any alerts (active, or closed) that are…

---

## [Monitor SQL Server Jobs Using DQL for Performance Insights](https://community.dynatrace.com/t/monitor-sql-server-jobs-using-dql-for-performance-insights/52087)

<div class="topic-metadata">

**Author:** [@DBAJames](https://community.dynatrace.com/u/DBAJames)\
**Replies:** 3\
**Last updated:** [January 28, 2026, 11:35am UTC](https://community.dynatrace.com/t/monitor-sql-server-jobs-using-dql-for-performance-insights/52087 "2026-01-28T11:35:46Z")

</div>

In the dashboard i have added the DQL from the example but it doesnt work as suggested. if i set it to 5 mins, i dont see any failed jobs. if i set it to 30 i get lots of duplication and sometimes ones that are no long…

---

## [Calculate Single Value P90](https://community.dynatrace.com/t/calculate-single-value-p90/54654)

<div class="topic-metadata">

**Author:** [@RPbiaggio](https://community.dynatrace.com/u/RPbiaggio)\
**Replies:** 3\
**Last updated:** [January 26, 2026, 6:33pm UTC](https://community.dynatrace.com/t/calculate-single-value-p90/54654 "2026-01-26T18:33:47Z")

</div>

Hi everyone, how’s it going? I need to calculate the p90 response time for some services in my environment. The problem is that I need to perform a split by to, among other things, extract the service tags, which will be…

---

## [Match nested span data based on time in DQL](https://community.dynatrace.com/t/match-nested-span-data-based-on-time-in-dql/54697)

<div class="topic-metadata">

**Author:** [@SimGiants92](https://community.dynatrace.com/u/SimGiants92)\
**Replies:** 2\
**Last updated:** [January 22, 2026, 7:48pm UTC](https://community.dynatrace.com/t/match-nested-span-data-based-on-time-in-dql/54697 "2026-01-22T19:48:45Z")

</div>

Hello, wondering if this is possible using DQL i gave it a solid try but cannot do it. I have the opentelemetry plugin installed on jenkins sending data to dynatrace. I would like to use the trace/span data to see all …

---

## [how get hostname from dt.source\_entity and dt.entity.process\_group\_instance](https://community.dynatrace.com/t/how-get-hostname-from-dt-source-entity-and-dt-entity-process-group-instance/54696)

<div class="topic-metadata">

**Author:** [@gasperetta](https://community.dynatrace.com/u/gasperetta)\
**Replies:** 2\
**Last updated:** [January 22, 2026, 8:27am UTC](https://community.dynatrace.com/t/how-get-hostname-from-dt-source-entity-and-dt-entity-process-group-instance/54696 "2026-01-22T08:27:49Z")

</div>

HI, I need to pull out the hostname associated with each process: this is my query… timeseries count = sum(dt.log.status\_per\_entity\_count, default: 0), by:{dt.source\_entity,dt.entity.process\_group,dt.entity.host} | fi…

---

## [consolidated monitoring from Database Service – Classic](https://community.dynatrace.com/t/consolidated-monitoring-from-database-service-classic/54688)

<div class="topic-metadata">

**Author:** [@karthikmv](https://community.dynatrace.com/u/karthikmv)\
**Replies:** 1\
**Last updated:** [January 21, 2026, 4:46pm UTC](https://community.dynatrace.com/t/consolidated-monitoring-from-database-service-classic/54688 "2026-01-21T16:46:09Z")

</div>

Hello Dynatrace Community, We are currently using Database Service – Classic and Dynatrace is able to successfully discover our Amazon Aurora PostgreSQL Global Cluster databases along with individual database details. H…

---

## [How do I return values which have returned 1?](https://community.dynatrace.com/t/how-do-i-return-values-which-have-returned-1/54693)

<div class="topic-metadata">

**Author:** [@badgerfifteen](https://community.dynatrace.com/u/badgerfifteen)\
**Replies:** 1\
**Last updated:** [January 21, 2026, 1:18pm UTC](https://community.dynatrace.com/t/how-do-i-return-values-which-have-returned-1/54693 "2026-01-21T13:18:54Z")

</div>

I have the following DQL code below: timeseries interval: 10m, file\_count = avg(filesystem.file\_count, filter: { ( in(\`dt.entity.filesystem:path\`, classicEntitySelector("type(filesystem:path),entityName.equals(\\"/link/l…

---

## [Workflow - Bring events into an email](https://community.dynatrace.com/t/workflow-bring-events-into-an-email/54644)

<div class="topic-metadata">

**Author:** [@munawarhossain3](https://community.dynatrace.com/u/munawarhossain3)\
**Replies:** 4\
**Last updated:** [January 20, 2026, 2:13pm UTC](https://community.dynatrace.com/t/workflow-bring-events-into-an-email/54644 "2026-01-20T14:13:13Z")

</div>

Hello, I want to bring the below data into an email via workflow. fetch events, from: now()-5m, to: now() | filter event.kind == “DAVIS\_PROBLEM” | filter event.status\_transition == “CREATED” | fields timestamp, disp…

---

## [Using a first query on second query data](https://community.dynatrace.com/t/using-a-first-query-on-second-query-data/54680)

<div class="topic-metadata">

**Author:** [@Ellery](https://community.dynatrace.com/u/Ellery)\
**Replies:** 2\
**Last updated:** [January 20, 2026, 12:08pm UTC](https://community.dynatrace.com/t/using-a-first-query-on-second-query-data/54680 "2026-01-20T12:08:42Z")

</div>

Hello people. i have big issue, im playing with spans, and y need obtains a metric. my query fetch spans | filter isNotNull( http.request.header.host) //| fields endpoint.name, http.request.header.host, http.request.m…

---

## [DQL query syntax while using in API calls](https://community.dynatrace.com/t/dql-query-syntax-while-using-in-api-calls/54663)

<div class="topic-metadata">

**Author:** [@harinhs](https://community.dynatrace.com/u/harinhs)\
**Replies:** 1\
**Last updated:** [January 18, 2026, 7:49pm UTC](https://community.dynatrace.com/t/dql-query-syntax-while-using-in-api-calls/54663 "2026-01-18T19:49:05Z")

</div>

I am trying to use this query to fetch remote environment data, but not working for remote environment through API call. But this works in local environment to get the host availability, fetch dt.entity.host | filterOu…

---

## [Extract data of MSISDN with multiple IMSI](https://community.dynatrace.com/t/extract-data-of-msisdn-with-multiple-imsi/54453)

<div class="topic-metadata">

**Author:** [@kumarv14](https://community.dynatrace.com/u/kumarv14)\
**Replies:** 8\
**Last updated:** [January 15, 2026, 12:58pm UTC](https://community.dynatrace.com/t/extract-data-of-msisdn-with-multiple-imsi/54453 "2026-01-15T12:58:31Z")

</div>

Hello all , i am new for DQL so i am trying to extract data of MSISDN against the IMSI where i have multiple IMSI , so is there any way so that query take IMSI and extract the MSISDN against those IMSI in one go . fet…

---

## [How to escape "\`" within "\`"?](https://community.dynatrace.com/t/how-to-escape-within/54642)

<div class="topic-metadata">

**Author:** [@Hillman](https://community.dynatrace.com/u/Hillman)\
**Replies:** 1\
**Last updated:** [January 15, 2026, 2:40am UTC](https://community.dynatrace.com/t/how-to-escape-within/54642 "2026-01-15T02:40:26Z")

</div>

The background of my question come from another post when I try to retrieve data from remote tenant and display in chart. (I am not able to include the post link here as the forum keep throwing error and remove the link…

---

## [Alert Creation](https://community.dynatrace.com/t/alert-creation/54633)

<div class="topic-metadata">

**Author:** [@Gib80](https://community.dynatrace.com/u/Gib80)\
**Replies:** 1\
**Last updated:** [January 14, 2026, 10:47pm UTC](https://community.dynatrace.com/t/alert-creation/54633 "2026-01-14T22:47:21Z")

</div>

Good Afternoon, I have been trying to create an alert for when a rate = 0.00 for ALL service names I have, but I’m unclear how to complete it. Any advise would be appreciated. Below is what I have already (created usi…

---

## [Need help with demo dashboard warnings DEMO](https://community.dynatrace.com/t/need-help-with-demo-dashboard-warnings-demo/54378)

<div class="topic-metadata">

**Author:** [@NicoleMT](https://community.dynatrace.com/u/NicoleMT)\
**Replies:** 4\
**Last updated:** [January 12, 2026, 6:53pm UTC](https://community.dynatrace.com/t/need-help-with-demo-dashboard-warnings-demo/54378 "2026-01-12T18:53:41Z")

</div>

Hello community, Could you please help me with this demo dashboard?: https://{environmentid}.apps.dynatrace.com/ui/apps/dynatrace.dashboards/dashboard/5c4c8356-8344-44e2-a726-e8c252387800#vfilter\_security\_context=&vfilt…

---

## [Timeseries arithmetic](https://community.dynatrace.com/t/timeseries-arithmetic/54580)

<div class="topic-metadata">

**Author:** [@Rudolph\_Sedlin](https://community.dynatrace.com/u/Rudolph_Sedlin)\
**Replies:** 2\
**Last updated:** [January 12, 2026, 1:09pm UTC](https://community.dynatrace.com/t/timeseries-arithmetic/54580 "2026-01-12T13:09:45Z")

</div>

I am currently sending percentage-based approval rate metrics to Dynatrace and creating line-graph dashboards using timeseries like these: timeseries APPROVAL\_RATE=avg(SERVICE\_APPROVAL\_RATE\_OVERALL), interval:1m That b…

---

## [Efficient way to join several time series commands when some of them return null values - is there any other way?](https://community.dynatrace.com/t/efficient-way-to-join-several-time-series-commands-when-some-of-them-return-null-values-is-there-any-other-way/54584)

<div class="topic-metadata">

**Author:** [@gilgi](https://community.dynatrace.com/u/gilgi)\
**Replies:** 2\
**Last updated:** [January 12, 2026, 6:57am UTC](https://community.dynatrace.com/t/efficient-way-to-join-several-time-series-commands-when-some-of-them-return-null-values-is-there-any-other-way/54584 "2026-01-12T06:57:43Z")

</div>

Hi, We have a situation in which we want to calculate (from logs) the percentage of errors from the total number of requests based on officename and apinames. It could happen that some of the offices/api’s will not expe…

---

## [Define business hours](https://community.dynatrace.com/t/define-business-hours/40002)

<div class="topic-metadata">

**Author:** [@sinisa\_zubic](https://community.dynatrace.com/u/sinisa_zubic)\
**Replies:** 6\
**Last updated:** [January 9, 2026, 12:19pm UTC](https://community.dynatrace.com/t/define-business-hours/40002 "2026-01-09T12:19:50Z")

</div>

Hi Team, how could I define business hours with DQL? I looked at filtering on the timestamp but can’t really find a way. For example: for monday to friday, 08am to 7pm.Best, Sini

---

## [Site Reliability Guardian: filter guardian runs bases on validation.from validation.to duration](https://community.dynatrace.com/t/site-reliability-guardian-filter-guardian-runs-bases-on-validation-from-validation-to-duration/54575)

<div class="topic-metadata">

**Author:** [@KevinB](https://community.dynatrace.com/u/KevinB)\
**Replies:** 2\
**Last updated:** [January 9, 2026, 9:45am UTC](https://community.dynatrace.com/t/site-reliability-guardian-filter-guardian-runs-bases-on-validation-from-validation-to-duration/54575 "2026-01-09T09:45:29Z")

</div>

I have 2 workflows running for 1 guardian 1 wich runs daily with data over 1 day 1 wich runs weekly with data over 1 week. Both runs are visible on the Guardian and when I query them I can see the difference in valida…

---

## [Timeline variable in Dashboard](https://community.dynatrace.com/t/timeline-variable-in-dashboard/54574)

<div class="topic-metadata">

**Author:** [@Mani\_Muthu3001](https://community.dynatrace.com/u/Mani_Muthu3001)\
**Replies:** 1\
**Last updated:** [January 9, 2026, 7:53am UTC](https://community.dynatrace.com/t/timeline-variable-in-dashboard/54574 "2026-01-09T07:53:19Z")

</div>

I have Timeline variable in Dashboard which is List Type and i provided values 30m, 1h, 2h which can be used as dropdown But when i tried to use Timeline variable in DQL , It is showing 0 records. But if i used without…

---

## [Getting error in DQL in fetching MQ information on filtering by QM names](https://community.dynatrace.com/t/getting-error-in-dql-in-fetching-mq-information-on-filtering-by-qm-names/54555)

<div class="topic-metadata">

**Author:** [@pds\_sis](https://community.dynatrace.com/u/pds_sis)\
**Replies:** 1\
**Last updated:** [January 8, 2026, 12:01pm UTC](https://community.dynatrace.com/t/getting-error-in-dql-in-fetching-mq-information-on-filtering-by-qm-names/54555 "2026-01-08T12:01:07Z")

</div>

Hi Team I am trying to filterout specific MQ’s however getting error “filter name”. Can anyone guide me on that please. This is the query : timeseries { availability = avg(ibmmq.queue\_manager.availability), dlq\_depth …

---

## [How to convert individual container cpu usage to DQL?](https://community.dynatrace.com/t/how-to-convert-individual-container-cpu-usage-to-dql/53205)

<div class="topic-metadata">

**Author:** [@Hillman](https://community.dynatrace.com/u/Hillman)\
**Replies:** 16\
**Last updated:** [January 8, 2026, 6:26am UTC](https://community.dynatrace.com/t/how-to-convert-individual-container-cpu-usage-to-dql/53205 "2026-01-08T06:26:33Z")

</div>

We are currently having a dashboard in gen2 UI that make use of builtin:containers.cpu.usagePercent to show not only the application pod CPU usage but also the pod count. However, when I try to convert it to gen3 das…

---

## [Query “Dynatrace z/OS module version” for CICS regions via DQL](https://community.dynatrace.com/t/query-dynatrace-z-os-module-version-for-cics-regions-via-dql/54534)

<div class="topic-metadata">

**Author:** [@Kajao](https://community.dynatrace.com/u/Kajao)\
**Replies:** 1\
**Last updated:** [January 6, 2026, 1:13pm UTC](https://community.dynatrace.com/t/query-dynatrace-z-os-module-version-for-cics-regions-via-dql/54534 "2026-01-06T13:13:20Z")

</div>

We have multiple CICS regions monitored on z/OS. In the Dynatrace UI (Hosts classic → Process → Properties & tags), each CICS region shows the property “Dynatrace z/OS module version” (for example, 1.300.0). For upgrade …

---

## [Convert MDA Queries into DQL for Advanced Analytics](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309)

<div class="topic-metadata">

**Author:** [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Replies:** 8\
**Last updated:** [January 2, 2026, 9:19am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309 "2026-01-02T09:19:05Z")

</div>

Hello Team, Is there a way to convert an MDA query into DQL or plot a chart on the dashboard without creating custom metrics? I’m looking to split metrics from dt.service.request.count by dt.entity.cloud\_application\_in…

---

## [Calculating BILLING\_USAGE\_EVENT data to currency](https://community.dynatrace.com/t/calculating-billing-usage-event-data-to-currency/54514)

<div class="topic-metadata">

**Author:** [@janne-olkoniemi](https://community.dynatrace.com/u/janne-olkoniemi)\
**Replies:** 4\
**Last updated:** [January 2, 2026, 8:52am UTC](https://community.dynatrace.com/t/calculating-billing-usage-event-data-to-currency/54514 "2026-01-02T08:52:41Z")

</div>

Hello, Could someone help me a bit with DQL queries since I’m feeling quite rusty with it currently :slightly\_smiling\_face: I would need to calculate the billing usage data on actual currency and not sure what could be…

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

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