topic DQL - Classic metric "billing.full_stack_monitoring.usage_per_host" in DQL

DQL - Classic metric "billing.full_stack_monitoring.usage_per_host"

AntonPineiro — Wed, 19 Nov 2025 16:53:32 GMT

Hi,

I would like to use this classic metric in new dashboard:

builtin:billing.full_stack_monitoring.usage_per_host:splitBy("dt.entity.host")

I have just not seen an equivalent in Grail. Which is equivalent to that metric using non classic selector?

Best regards

Re: DQL - Classic metric in new dashboard

Kenny_Gillette — Tue, 18 Nov 2025 15:59:43 GMT

I used Account management then looked at full stack monitoring in a notebook. Here is a dql that may help?

fetch dt.system.events
| filter event.kind == "BILLING_USAGE_EVENT" and event.type == "Full-Stack Monitoring"
| dedup event.id
| summarize billed_gibibyte = sum(billed_gibibyte_hours), by:{dt.entity.host}
| fields host_id = dt.entity.host, host_name = entityAttr(dt.entity.host, "entity.name"), billed_gibibyte
| sort billed_gibibyte DESC

I am sure you have seen this post?

https://community.dynatrace.com/t5/DPS-Cost-Allocation/DPS-Cost-Allocation-Dashboard-UPDATED-v3-3/td-p/268578

Re: DQL - Classic metric in new dashboard

Julius_Loman — Tue, 18 Nov 2025 16:27:08 GMT

This metric is not available and the billing events are the right way to go.

Re: DQL - Classic metric in new dashboard

AntonPineiro — Wed, 19 Nov 2025 16:52:34 GMT

Hi,

Equivalent DQL query would like using makeTimeseries command:

fetch dt.system.events | filter event.kind == "BILLING_USAGE_EVENT" and event.type == "Full-Stack Monitoring" | dedup event.id | fieldsAdd host_id = dt.entity.host, host_name =entityName(dt.entity.host), billed_gibibyte | makeTimeseries billed_gibibyte = avg(billed_gibibyte_hours) , by: {host_name} | sort billed_gibibyte DESC

Best regards