DQL
Questions about Dynatrace Query Language
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

cost of the “Browser Monitor or Clickpath” capacity in a dashboard

atehard
Newcomer_

Hi,

I want to display the monthly cost of the “Browser Monitor or Clickpath” capacity in a dashboard. I can't find any elements in dt.system.events as I can for other capacities.

builtin:billing.synthetic.actions.usage_by_browser_monitor:splitBy():sort(value(auto,descending)):limit(20)

atehard_0-1764864635572.png

Is it possible to convert the query below from the data explorer into a DQL query? 

Below is the expected result format in the dashboard, for example

atehard_1-1764864789163.png

Thanks

Aurélie

 

2 REPLIES 2

AntonPineiro
DynaMight Guru
DynaMight Guru

Hi,

Are you in DPS model?

Looks like RUM and Synthetics cost are not in DQL format.

Best regards

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

mark_bley
Dynatrace Champion
Dynatrace Champion

we will have to wait until Synthetics are also in Grail

For now you can always use the DT SDK

/*
* This function will run in the DYNATRACE JavaScript runtime.
* For information visit https://dt-url.net/functions-help
*/

import { metricsClient } from "@dynatrace-sdk/client-classic-environment-v2";

export default async function () {

  const data = await metricsClient.query({
    acceptType: "application/json; charset=utf-8",
    resolution: "1M",
    from: "-9M/M",
    to: "now/M",
    metricSelector: "builtin:billing.synthetic.actions.usage_by_browser_monitor:splitBy():sort(value(auto,descending)):limit(20)"
  });
  console.log(data.result[0].data[0].values)
  return data.result[0].data[0].values;
}

you will need to play around a bit with the timestamp and values fields to get the right format you want for the table.

Featured Posts