Query Daily License Consumption per Host Using DQL

NicoleMT — Wed, 17 Dec 2025 12:45:45 GMT

Hello, could you help me with a DQL query to get the daily license consumption of my hosts? I would like the results to be detailed per host. If there is another way to view this information directly in Dynatrace, I would also like to know. Thank you!

Re: DQL Query for Daily License Consumption per Host

p_devulapalli — Wed, 29 Oct 2025 22:19:20 GMT

@NicoleMT Take a look at the Cost Allocation dashboard below, it has some views that might help you. "Host usage and cost summary" view is what relates to your query

https://community.dynatrace.com/t5/DPS-Cost-Allocation/DPS-Cost-Allocation-Dashboard-V1-2/m-p/260595

https://docs.dynatrace.com/docs/license/cost-allocation

Re: DQL Query for Daily License Consumption per Host

t_pawlak — Thu, 30 Oct 2025 10:11:32 GMT

Hi,
you can try this:

fetch dt.system.events, scanLimitGBytes: -1 | filter event.kind == "BILLING_USAGE_EVENT" | filter event.type == "Full-Stack Monitoring" | filter isNotNull(dt.entity.host) | dedup event.id | summarize fs_gibih = sum(billed_gibibyte_hours), by: { day = bin(timestamp, 1d), hostId = dt.entity.host } | lookup [ fetch dt.entity.host ], sourceField: hostId, lookupField: id

And this (not tested, i don't have enviroment to test it)

fetch dt.system.events, scanLimitGBytes: -1 | filter event.kind == "BILLING_USAGE_EVENT" | filter event.type == "Infrastructure Monitoring" | filter isNotNull(dt.entity.host) | dedup event.id | summarize infra_hosth = sum(billed_host_hours), by: { day = bin(timestamp, 1d), hostId = dt.entity.host } | lookup [ fetch dt.entity.host ], sourceField: hostId, lookupField: id

fetch dt.system.events, scanLimitGBytes: -1
Fetches system events from storage (with no scan limit in this query).

| filter event.kind == "BILLING_USAGE_EVENT"
Keeps only billing-related events.

| filter event.type == "Full-Stack Monitoring"
Narrows to the “Full-Stack Monitoring” billing type (where fields like billed_gibibyte_hours are present).

| filter isNotNull(dt.entity.host)
Keeps only events that are linked to a specific host (i.e., have dt.entity.host).

| dedup event.id
Removes any duplicate events using the unique event.id.

| summarize fs_gibih = sum(billed_gibibyte_hours), by: { day = bin(timestamp, 1d), hostId = dt.entity.host }
Aggregates data so you get one row per (day, host):

day — timestamp bucketed to 1 day (bin(..., 1d)),
hostId — the host entity ID (e.g., HOST-...),
fs_gibih — the sum of billed_gibibyte_hours for that host on that day.

topic Query Daily License Consumption per Host Using DQL in DQL

Query Daily License Consumption per Host Using DQL

Re: DQL Query for Daily License Consumption per Host

Re: DQL Query for Daily License Consumption per Host