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!
@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.
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.