Fetch Dashboard Name by ID Using DQL Queries

I am attempting to obtain the amount of data scanned by DQLs at dashboard level. Could someone assist me in obtaining the dashboard name as a dimension, in addition to the dashboard ID? I have attached the DQL.

Basically, how to get dashboard name using id? Appreciate your help, thanks!

fetch dt.system.events
| filter event.kind == "BILLING_USAGE_EVENT"
| filter event.type == "Log Management & Analytics - Query"
| filter client.application_context == "dynatrace.dashboards"
| parse client.source, "DATA 'ui/dashboard/' STRING:dashboard.id"
| dedup event.id
| summarize {
   data_read_bytes = toDouble(sum(billed_bytes)),
   Query_count = count()
  }, by: {
    dashboard.id
    // , name?
  }
| sort data_read_bytes desc

dql1.pdf (64.7 KB)

@chandu I think your best option here would be to use a lookup table that has the dashaboard.id and dashboard name mapping and use it as part of the query. Not sure dashboard name is actually available as a field via DQL

@p_devulapalli Thank you. Yes, lookup is the choice if we want to join data from source query with a subquery. But the question is does Dynatrace expose mapping between dashboard name and id via any of the system tables.

@chandu I am bit doubtful if dashboard name is stored in any of the system tables, will leave this open for anyone to comment on further

Agreed. But you can use Code tile instead - run the DQL and accessing a Dynatrace Platform Document API to fetch the name. Dashboards are not stored in DQL afaik.