# DQL

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

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

**Page:** 3

---

## [DQL query on disk free space](https://community.dynatrace.com/t/dql-query-on-disk-free-space/50251)

<div class="topic-metadata">

**Author:** [@akashsaini](https://community.dynatrace.com/u/akashsaini)\
**Replies:** 6\
**Last updated:** [April 28, 2026, 7:10am UTC](https://community.dynatrace.com/t/dql-query-on-disk-free-space/50251 "2026-04-28T07:10:02Z")

</div>

Hi Team, We require DQL query on disk free space with OS type. Information require through dql query -- disk free space for /opt/ directory os type-like Linux ubuntu , AIX Thanks in advance !

---

## [billing metrics](https://community.dynatrace.com/t/billing-metrics/55708)

<div class="topic-metadata">

**Author:** [@marusla](https://community.dynatrace.com/u/marusla)\
**Replies:** 1\
**Last updated:** [April 24, 2026, 8:01pm UTC](https://community.dynatrace.com/t/billing-metrics/55708 "2026-04-24T20:01:20Z")

</div>

is there a way to see this metrics builtin:billing.full\_stack\_monitoring.usage\_per\_host:splitBy(“dt.entity.host”):sort(value(auto,descending)):limit(20) in a new dashboard, or in dql

---

## [More efficient way to filter spans by service tags in DQL?](https://community.dynatrace.com/t/more-efficient-way-to-filter-spans-by-service-tags-in-dql/55707)

<div class="topic-metadata">

**Author:** [@arobayo17](https://community.dynatrace.com/u/arobayo17)\
**Replies:** 1\
**Last updated:** [April 24, 2026, 4:53pm UTC](https://community.dynatrace.com/t/more-efficient-way-to-filter-spans-by-service-tags-in-dql/55707 "2026-04-24T16:53:59Z")

</div>

Hi everyone, I’m currently working with a DQL query that fetches spans and filters them based on a tag applied to the service (or process group) the span belongs to. In my dashboard, I created a variable that contains …

---

## [link log to existing entity](https://community.dynatrace.com/t/link-log-to-existing-entity/55680)

<div class="topic-metadata">

**Author:** [@FabriBernie](https://community.dynatrace.com/u/FabriBernie)\
**Replies:** 2\
**Last updated:** [April 23, 2026, 2:45pm UTC](https://community.dynatrace.com/t/link-log-to-existing-entity/55680 "2026-04-23T14:45:48Z")

</div>

I had importing log using API because of technology not currently supported I don’t have any enrichment with context information However, name of k8s cluster and namespace is there Is there a way to link these rows …

---

## [DQL to pull all Endpoints\\Requests for a particular Service](https://community.dynatrace.com/t/dql-to-pull-all-endpoints-requests-for-a-particular-service/55656)

<div class="topic-metadata">

**Author:** [@dkrishna](https://community.dynatrace.com/u/dkrishna)\
**Replies:** 7\
**Last updated:** [April 23, 2026, 11:56am UTC](https://community.dynatrace.com/t/dql-to-pull-all-endpoints-requests-for-a-particular-service/55656 "2026-04-23T11:56:53Z")

</div>

Hi, I am trying to pull all the endpoints of a service but i am unable to fetch instead we can fetch only the endpoints which are marked key requests. Need help on this. Please let me know if you are unclear on questio…

---

## [Problems with timeframe Dashboard](https://community.dynatrace.com/t/problems-with-timeframe-dashboard/55645)

<div class="topic-metadata">

**Author:** [@davidvm02-giss](https://community.dynatrace.com/u/davidvm02-giss)\
**Replies:** 3\
**Last updated:** [April 21, 2026, 3:20pm UTC](https://community.dynatrace.com/t/problems-with-timeframe-dashboard/55645 "2026-04-21T15:20:46Z")

</div>

Good afternoon, We have a trace dashboard with two links that redirect to the classic backtrace and service flow views for the service selected via the variable. I’d like the URL to not only use the service via the var…

---

## [Is it possible to get Extension Configurations via DQL?](https://community.dynatrace.com/t/is-it-possible-to-get-extension-configurations-via-dql/55631)

<div class="topic-metadata">

**Author:** [@JoseT](https://community.dynatrace.com/u/JoseT)\
**Replies:** 2\
**Last updated:** [April 21, 2026, 1:15pm UTC](https://community.dynatrace.com/t/is-it-possible-to-get-extension-configurations-via-dql/55631 "2026-04-21T13:15:12Z")

</div>

Basically as described. Is it possible? We can get their ids by using fetch \`dt.entity.extensions:configuration\` but not their contents. It would be immensely quicker to do it via DQL (and safer!), instead of having…

---

## [Service Failure rate by host](https://community.dynatrace.com/t/service-failure-rate-by-host/55604)

<div class="topic-metadata">

**Author:** [@jmistry](https://community.dynatrace.com/u/jmistry)\
**Replies:** 10\
**Last updated:** [April 17, 2026, 11:02am UTC](https://community.dynatrace.com/t/service-failure-rate-by-host/55604 "2026-04-17T11:02:53Z")

</div>

Hello, Is there a way where i can see service failure rate but have it split by host. we have the same services on multi different host and want to see all services on all host and their failure rate? Maybe a DQL que…

---

## [DQL missing data points and Data Explorer complete](https://community.dynatrace.com/t/dql-missing-data-points-and-data-explorer-complete/55574)

<div class="topic-metadata">

**Author:** [@elenaperez](https://community.dynatrace.com/u/elenaperez)\
**Replies:** 3\
**Last updated:** [April 15, 2026, 7:38pm UTC](https://community.dynatrace.com/t/dql-missing-data-points-and-data-explorer-complete/55574 "2026-04-15T19:38:55Z")

</div>

When running the same query in the data explorer and in DQL, DQL one misses some data points. Is this normal? Is there a way to fix it? Thanks in advance!

---

## [Pro-Tip: Advanced Queries for Grail Partitioning](https://community.dynatrace.com/t/pro-tip-advanced-queries-for-grail-partitioning/55573)

<div class="topic-metadata">

**Author:** [@martin\_goodwell](https://community.dynatrace.com/u/martin_goodwell)\
**Replies:** 2\
**Last updated:** [April 15, 2026, 8:38am UTC](https://community.dynatrace.com/t/pro-tip-advanced-queries-for-grail-partitioning/55573 "2026-04-15T08:38:41Z")

</div>

As an extension to the Grail Partitioning Guide, this thread shows a collection of advanced analytics queries. These allow you to check if a partitioning strategy based on query behavior works for your environment. Usin…

---

## [DQL - Extract value from a metric dimension and convert it to a timeseries metric](https://community.dynatrace.com/t/dql-extract-value-from-a-metric-dimension-and-convert-it-to-a-timeseries-metric/51657)

<div class="topic-metadata">

**Author:** [@36Krazyfists](https://community.dynatrace.com/u/36Krazyfists)\
**Replies:** 4\
**Last updated:** [April 14, 2026, 7:39pm UTC](https://community.dynatrace.com/t/dql-extract-value-from-a-metric-dimension-and-convert-it-to-a-timeseries-metric/51657 "2026-04-14T19:39:39Z")

</div>

For the life of me, I cannot imagine why whomever created the F5 Extension in Dynatrace set the state metrics (for things like Pool State, Pool Member State, etc…) to always be 1 and to have the actual availability state…

---

## [How to query process\_group\_instance that belongs to a specific process\_group?](https://community.dynatrace.com/t/how-to-query-process-group-instance-that-belongs-to-a-specific-process-group/55530)

<div class="topic-metadata">

**Author:** [@albertokirey](https://community.dynatrace.com/u/albertokirey)\
**Replies:** 3\
**Last updated:** [April 13, 2026, 11:22am UTC](https://community.dynatrace.com/t/how-to-query-process-group-instance-that-belongs-to-a-specific-process-group/55530 "2026-04-13T11:22:07Z")

</div>

Hello, I would like to build a graph with the heap memory used of all process\_group\_instance that belongs to a specific process\_group. I’m trying this: timeseries avg(dt.runtime.jvm.memory\_pool.used), by:{dt.entity.pr…

---

## [is it possible to evaluate service response time using DQL query](https://community.dynatrace.com/t/is-it-possible-to-evaluate-service-response-time-using-dql-query/42913)

<div class="topic-metadata">

**Author:** [@heramb\_sawant](https://community.dynatrace.com/u/heramb_sawant)\
**Replies:** 4\
**Last updated:** [April 10, 2026, 7:48pm UTC](https://community.dynatrace.com/t/is-it-possible-to-evaluate-service-response-time-using-dql-query/42913 "2026-04-10T19:48:02Z")

</div>

Hi , I am working on SRG . Creating one guardian having objectives at application level like , 1. Application / Service Response time 2.Service Success Rate % Also looking for container level metrics, Does Dynatrac…

---

## [Regex/Parsing logic to extract nested or repeating patterns from a specific data record format](https://community.dynatrace.com/t/regex-parsing-logic-to-extract-nested-or-repeating-patterns-from-a-specific-data-record-format/55476)

<div class="topic-metadata">

**Author:** [@TrunksGr](https://community.dynatrace.com/u/TrunksGr)\
**Replies:** 1\
**Last updated:** [April 6, 2026, 6:27am UTC](https://community.dynatrace.com/t/regex-parsing-logic-to-extract-nested-or-repeating-patterns-from-a-specific-data-record-format/55476 "2026-04-06T06:27:58Z")

</div>

I am looking for a way to extract specific substrings from a data record. I need to retrieve all values associated with the key Valuethat are contained inside the value="..." attribute of a data record. data record(cont…

---

## [dt.davis.analysis\_trigger\_delay - evaluation](https://community.dynatrace.com/t/dt-davis-analysis-trigger-delay-evaluation/55467)

<div class="topic-metadata">

**Author:** [@munawarhossain3](https://community.dynatrace.com/u/munawarhossain3)\
**Replies:** 3\
**Last updated:** [April 5, 2026, 8:54am UTC](https://community.dynatrace.com/t/dt-davis-analysis-trigger-delay-evaluation/55467 "2026-04-05T08:54:13Z")

</div>

Hello, I’ve created a process availability alert and want to delay it by 1 minute. So, I added property as (enclosed, image 1 and 2). Now, which is the right way (1 or 2)? How Dynatrace is going to evaluate this? Th…

---

## [Need to extract logs on behalf of Opco and IMSI variable](https://community.dynatrace.com/t/need-to-extract-logs-on-behalf-of-opco-and-imsi-variable/55201)

<div class="topic-metadata">

**Author:** [@kumarv14](https://community.dynatrace.com/u/kumarv14)\
**Replies:** 4\
**Last updated:** [April 3, 2026, 10:22am UTC](https://community.dynatrace.com/t/need-to-extract-logs-on-behalf-of-opco-and-imsi-variable/55201 "2026-04-03T10:22:40Z")

</div>

Hello everyone and @krzysztof\_hoja , Can someone help me create a dashboard that uses two input values — Market (OpCo) and IMSI? I want the dashboard to accept these two values as variables, and then display the logs b…

---

## [Need hep in pulling nested json log line as seprate line with DPL](https://community.dynatrace.com/t/need-hep-in-pulling-nested-json-log-line-as-seprate-line-with-dpl/55450)

<div class="topic-metadata">

**Author:** [@Dest-Roh](https://community.dynatrace.com/u/Dest-Roh)\
**Replies:** 4\
**Last updated:** [April 3, 2026, 5:53am UTC](https://community.dynatrace.com/t/need-hep-in-pulling-nested-json-log-line-as-seprate-line-with-dpl/55450 "2026-04-03T05:53:46Z")

</div>

Hi Team i need an help in converting below nested json to multiple lines in log processing rule with DPL syntax but unfortunately i am unable to pull all record. Additinalinfo: DATA DETAILS: { “Report”:\[{“SessionID”:…

---

## [Fetch Database Host](https://community.dynatrace.com/t/fetch-database-host/55336)

<div class="topic-metadata">

**Author:** [@gokmen](https://community.dynatrace.com/u/gokmen)\
**Replies:** 8\
**Last updated:** [April 3, 2026, 5:26am UTC](https://community.dynatrace.com/t/fetch-database-host/55336 "2026-04-03T05:26:44Z")

</div>

Hi all , we want to make an availability dashboard only for Database hosts. Is there a way of fetching only Database hosts. So not to add a newly added host to our DQL filter every time. Thanks in advance

---

## [DQL for cumulative percentage of time](https://community.dynatrace.com/t/dql-for-cumulative-percentage-of-time/55432)

<div class="topic-metadata">

**Author:** [@elenaperez](https://community.dynatrace.com/u/elenaperez)\
**Replies:** 3\
**Last updated:** [April 1, 2026, 10:51am UTC](https://community.dynatrace.com/t/dql-for-cumulative-percentage-of-time/55432 "2026-04-01T10:51:59Z")

</div>

Hi team! I have the following query: fetch spans | filter matchesValue(dt.system.bucket, "obs-educamosclm\_spans") | fieldsAdd duration = toDuration(end\_time-start\_time), request.is\_failed | fieldsAdd failed = if(reques…

---

## [Metric Events Query Failed - missing alerts](https://community.dynatrace.com/t/metric-events-query-failed-missing-alerts/55428)

<div class="topic-metadata">

**Author:** [@Vijayt](https://community.dynatrace.com/u/Vijayt)\
**Replies:** 2\
**Last updated:** [March 31, 2026, 2:45pm UTC](https://community.dynatrace.com/t/metric-events-query-failed-missing-alerts/55428 "2026-03-31T14:45:02Z")

</div>

Hi i am configuring Warning alerts for OS mount points only not application mount points. Configured it using DSQL with filtering disk names /, /opt, /var but i am getting metric event QUERY\_FAILED. builtin:host.disk.…

---

## [Localized time in workflows?](https://community.dynatrace.com/t/localized-time-in-workflows/43352)

<div class="topic-metadata">

**Author:** [@calfano](https://community.dynatrace.com/u/calfano)\
**Replies:** 4\
**Last updated:** [March 31, 2026, 2:16pm UTC](https://community.dynatrace.com/t/localized-time-in-workflows/43352 "2026-03-31T14:16:08Z")

</div>

I’m writing a DQL Block in workflows and I’ve noticed the times comes back in UTC time. Is there an easy way to localize DQL executions within workflows? Thank you!

---

## [DQL - Anomaly detector interval 1m](https://community.dynatrace.com/t/dql-anomaly-detector-interval-1m/55385)

<div class="topic-metadata">

**Author:** [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Replies:** 2\
**Last updated:** [March 27, 2026, 1:57pm UTC](https://community.dynatrace.com/t/dql-anomaly-detector-interval-1m/55385 "2026-03-27T13:57:11Z")

</div>

Hi, I would like to create an anomaly detector disk alert when disk is higher than some value. I am trying it using this DQL: timeseries t\_disk = avg(dt.host.disk.used.percent), filter: { matchesValue(role, "ORACLE")…

---

## [Difference DQL Calculate diference of two timeseries metrics](https://community.dynatrace.com/t/difference-dql-calculate-diference-of-two-timeseries-metrics/55378)

<div class="topic-metadata">

**Author:** [@robert\_laurat](https://community.dynatrace.com/u/robert_laurat)\
**Replies:** 2\
**Last updated:** [March 27, 2026, 7:04am UTC](https://community.dynatrace.com/t/difference-dql-calculate-diference-of-two-timeseries-metrics/55378 "2026-03-27T07:04:19Z")

</div>

Hi everyone, I want to create a difference between two metrics over the time. For example to show the differnece between published and processed queue messages. How to do this with DQL? I tried to start with this comm…

---

## [Classic Dashboard vs DQL: Problem Count Differences Using Management Zones](https://community.dynatrace.com/t/classic-dashboard-vs-dql-problem-count-differences-using-management-zones/55333)

<div class="topic-metadata">

**Author:** [@Gabriel\_BR](https://community.dynatrace.com/u/Gabriel_BR)\
**Replies:** 3\
**Last updated:** [March 24, 2026, 7:31pm UTC](https://community.dynatrace.com/t/classic-dashboard-vs-dql-problem-count-differences-using-management-zones/55333 "2026-03-24T19:31:24Z")

</div>

I need to update a classic dashboard to DQL. However, in the classic dashboard it points to both open and closed problems based on the Management Zone (MZ). In the new model, I’m not able to achieve the same result. It…

---

## [Extension to show new version in Dashboard tile](https://community.dynatrace.com/t/extension-to-show-new-version-in-dashboard-tile/54815)

<div class="topic-metadata">

**Author:** [@Mani\_Muthu3001](https://community.dynatrace.com/u/Mani_Muthu3001)\
**Replies:** 2\
**Last updated:** [March 24, 2026, 12:02am UTC](https://community.dynatrace.com/t/extension-to-show-new-version-in-dashboard-tile/54815 "2026-03-24T00:02:51Z")

</div>

Hi Experts, I need to create one of the tile in dashboard. Below is the requirement - We have multiple extensions in our environment - We need to show the current active version of that extension and also to show the …

---

## [Access to the resource is forbidden using Power BI Dynatrace Grail DQL Connector for smartscape commands in DQL](https://community.dynatrace.com/t/access-to-the-resource-is-forbidden-using-power-bi-dynatrace-grail-dql-connector-for-smartscape-commands-in-dql/55279)

<div class="topic-metadata">

**Author:** [@AlanFoley](https://community.dynatrace.com/u/AlanFoley)\
**Replies:** 1\
**Last updated:** [March 17, 2026, 1:47pm UTC](https://community.dynatrace.com/t/access-to-the-resource-is-forbidden-using-power-bi-dynatrace-grail-dql-connector-for-smartscape-commands-in-dql/55279 "2026-03-17T13:47:18Z")

</div>

Hi I am trying to get the following DQL commands working using Power BI Dynatrace Grail DQL Connector DQL commands like: “fetch dt.system.events” or “fetch dt.entity.host” all work 100% so I have permission to access D…

---

## [How to retrieve data from another tenant and display in chart through DQL](https://community.dynatrace.com/t/how-to-retrieve-data-from-another-tenant-and-display-in-chart-through-dql/54504)

<div class="topic-metadata">

**Author:** [@Hillman](https://community.dynatrace.com/u/Hillman)\
**Replies:** 13\
**Last updated:** [March 16, 2026, 2:12pm UTC](https://community.dynatrace.com/t/how-to-retrieve-data-from-another-tenant-and-display-in-chart-through-dql/54504 "2026-03-16T14:12:45Z")

</div>

We have created some charts which display the data from another tenant. In gen2 version, it can be configured like this: When I try to convert the chart to gen3 version, I am not sure how to use DQL to achieve this. …

---

## [fetch connected hosts count to each active gate and display trends with DQL](https://community.dynatrace.com/t/fetch-connected-hosts-count-to-each-active-gate-and-display-trends-with-dql/55230)

<div class="topic-metadata">

**Author:** [@Sisapy09](https://community.dynatrace.com/u/Sisapy09)\
**Replies:** 1\
**Last updated:** [March 11, 2026, 9:32am UTC](https://community.dynatrace.com/t/fetch-connected-hosts-count-to-each-active-gate-and-display-trends-with-dql/55230 "2026-03-11T09:32:36Z")

</div>

any have DQL to get the some upgrade problems and hosts connected to AG. we can see them in deployment page but just checking if possible to get that from DQL.

---

## [Access to SQL Bind variables on spans in Grail](https://community.dynatrace.com/t/access-to-sql-bind-variables-on-spans-in-grail/55220)

<div class="topic-metadata">

**Author:** [@EduardLaGrange](https://community.dynatrace.com/u/EduardLaGrange)\
**Replies:** 1\
**Last updated:** [March 10, 2026, 9:54am UTC](https://community.dynatrace.com/t/access-to-sql-bind-variables-on-spans-in-grail/55220 "2026-03-10T09:54:15Z")

</div>

Does anyone know if 1) it is possible to access SQL bind variables in DQL (on spans), if it is how to reference it?

---

## [Perform a pattern check: after one API call, immediately verify the next API call and, for a specified API, extract the result](https://community.dynatrace.com/t/perform-a-pattern-check-after-one-api-call-immediately-verify-the-next-api-call-and-for-a-specified-api-extract-the-result/55108)

<div class="topic-metadata">

**Author:** [@kumarv14](https://community.dynatrace.com/u/kumarv14)\
**Replies:** 2\
**Last updated:** [March 6, 2026, 12:26pm UTC](https://community.dynatrace.com/t/perform-a-pattern-check-after-one-api-call-immediately-verify-the-next-api-call-and-for-a-specified-api-extract-the-result/55108 "2026-03-06T12:26:15Z")

</div>

we have attach image of our result but we wants to check in single query -: after one API call, check the next API call; for a specific API, extract the result of the subsequent API.we want to count how many IMSIs have D…

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

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