# DQL Dashboard Queries

**URL:** <https://community.dynatrace.com/t/dql-dashboard-queries/41904>\
**Category:** DQL\
**Tags:** dql, dynatrace-managed\
**Created:** [October 3, 2023, 5:47pm UTC](https://community.dynatrace.com/t/dql-dashboard-queries/41904 "2023-10-03T17:47:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![danielD](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@danielD](https://community.dynatrace.com/u/danielD)\
**Post date:** [October 3, 2023, 5:47pm UTC](https://community.dynatrace.com/t/dql-dashboard-queries/41904/1 "2023-10-03T17:47:06Z")

</div>

Hello,

As I understand it not all Dynatrace metrics are currently in grail. For the metrics that are not, can you still use dql to query those metrics, for instance on the new dashboard app? Or do you have to create those tiles a different way?

Thank you

---

<div class="post-metadata">

**Author:** ![natanael\_mendes](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/natanael_mendes/32/15264_2.png) [@natanael\_mendes](https://community.dynatrace.com/u/natanael_mendes)\
**Post date:** [October 3, 2023, 9:46pm UTC](https://community.dynatrace.com/t/dql-dashboard-queries/41904/2 "2023-10-03T21:46:38Z")

</div>

you can create new metrics for this, and them they will be available on the grail

---

<div class="post-metadata">

**Author:** ![gbaudart](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gbaudart](https://community.dynatrace.com/u/gbaudart)\
**Post date:** [January 10, 2024, 10:10pm UTC](https://community.dynatrace.com/t/dql-dashboard-queries/41904/3 "2024-01-10T22:10:49Z")

</div>

Hi&nbsp;[@danielD](https://community.dynatrace.com/user/50619)&nbsp;,  
The metrics and SLOs aren’t available with grail.

To obtain them, you must use the SDK classic environment APIs, while waiting for these features to arrive natively in Grail.  
It shouldn’t be long

---

<div class="post-metadata">

**Author:** ![rgarzon1](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/rgarzon1/32/11844_2.png) [@rgarzon1](https://community.dynatrace.com/u/rgarzon1)\
**Post date:** [January 11, 2024, 6:58am UTC](https://community.dynatrace.com/t/dql-dashboard-queries/41904/4 "2024-01-11T06:58:54Z")

</div>

DanielD

You can use this in the notebooks or dashboards to get the metrics that you use in the dataexplorer

```javascript
import { metricsClient } from '@dynatrace-sdk/client-classic-environment-v2';

export default async function () {
    const metricSelectorString = "builtin:service.response.time:splitBy():fold:avg";
    const resp = await metricsClient.query({
        metricSelector: metricSelectorString,
        acceptType: "application/json; charset=utf-8",
    });
    let outarray = [];
    for (let rate of resp.result[0].data) {
        let i = 0;
        for (let ts of rate.timestamps) {
            i++;
            let date = new Date(ts);
            outarray.push({
                'Timestamp': date,
                'miliSeconds': rate.values/1000,
            });
        }
    }
    return outarray;
}

```

 ![rgarzon1_0-1704956243727.png](https://global.discourse-cdn.com/dynatrace/original/3X/d/0/d0e586dae9b8d8d5ca2ac82389146b4294b39795.png)

PD: i just notice that this is from 3 months ago, but well you can always have new ways to doit.