topic DQL Dashboard Queries in DQL

DQL Dashboard Queries

danielD — Tue, 03 Oct 2023 17:47:06 GMT

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

Re: DQL Dashboard Queries

natanael_mendes — Tue, 03 Oct 2023 21:46:38 GMT

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

Re: DQL Dashboard Queries

gbaudart — Wed, 10 Jan 2024 22:10:49 GMT

Hi @danielD ,
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

Re: DQL Dashboard Queries

rgarzon1 — Thu, 11 Jan 2024 06:58:54 GMT

DanielD

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

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; }

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