DQL - Classic metric "billing.full_stack_monitoring.usage_per_host"

[AntonPineiro]

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

[Kenny_Gillette]

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

[Julius_Loman]

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

[AntonPineiro · Accepted solution]

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