I would like to know where I can visualize how many host units each host consumes. In the previous account management design I had that option and I could export that data, but with the new design I can’t find that section.
I use this formula in Data Explorer to show the amount of HU by host by hour:
(builtin:billing.ddu.includedMetricPerHost:splitBy(“dt.entity.host”):avg:auto:sort(value(avg,descending)):limit(100))/(1000)
Infra only: (builtin:billing.ddu.includedMetricPerHost:filter(and(or(in(“dt.entity.host”,entitySelector(“type(host),monitoringMode(~“CLOUD_INFRA~”)”))))):splitBy(“dt.entity.host”):avg:auto:sort(value(avg,descending)):limit(100))/(1000)/(80)
Dynatrace runs a script that populates the billing hostunit ddu metric every 15 minutes. And only gives a grand total.. I am no expert in Dataexplorer and not a big fan of manually entered entitySelector based queries, since they are not selectable in the dropdown list and all manually entered text is prone to errors.
So I decided to run a scheduled script to query the api and fetch the hostunit count for all hosts and I store the HostUnit count as a custom metric ‘HostUnits’ on those hosts
We now have a nice way to slice and dice HU consumption from the Data Explorer ui. I can Split on hosts, filter on tags, management zones, hostgroups and some history..
This is a workaround of course.
It would be so nice if HU consumption was just made available as queryable host metadata, metric or property readily available in data explorer dropdown UI.
Thank you so much for the formula! You’re a saver! The formulas you posted worked like a charm for me!
I am not yet experienced with composing these formulas and now I am struggling to get a single value from them.
Basically using your formulas, I was able to get the HU consumption per host for each management zone. Now I want to add another tile that shows me the HU consumption as one number for the whole management zone. I know I should add some aggregation to your formula, but I am not sure how to do so. Can you help me with that?
In case anybody else in wondering the same thing, you get 1000 included metrics per host unit (see DDUs for metrics — Dynatrace Docs). So if you divide the number of included metrics by 1000, you get the number of host units