topic Re: How can I vizualize the host consumption per host? in Open Q&A

How can I vizualize the host consumption per host?

soportetr — Fri, 12 May 2023 08:54:21 GMT

Hi everyone,

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.

Thanks in advance

Re: How can I vizualize the host consumption per host?

dannemca — Thu, 11 May 2023 18:52:29 GMT

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)

Try and let us know.

Re: How can I vizualize the host consumption per host?

soportetr — Thu, 11 May 2023 19:26:53 GMT

Hi @dannemca

Thank you for your response. This formula will be very helpful. I just need to adjust it to show me the exact amount of host unit per host.

Re: How can I vizualize the host consumption per host?

dannemca — Thu, 11 May 2023 19:59:15 GMT

If you set your timeframe to last 1h, you will see the exactly amount of HU by host. At least the ones with fullstack.

Re: How can I vizualize the host consumption per host?

Ahmed_Khaled — Mon, 15 May 2023 10:07:48 GMT

My team and I took the original formula and we edited it a bit to get the consumption for Full stack and for Infra only as well

Fullstack: (builtin:billing.ddu.includedMetricPerHost:filter(and(or(in("dt.entity.host",entitySelector("type(host),monitoringMode(~"FULL_STACK~")"))))):splitBy("dt.entity.host"):avg:auto:sort(value(avg,descending)):limit(200))/(1000)/(61)

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)

Re: How can I vizualize the host consumption per host?

Viachaslau — Mon, 15 May 2023 10:20:25 GMT

The simplest way get info via API and parse into CSV
maybe with new dashboard we can do it inside dyna, since external call possible to attach...

"""https://www.dynatrace.com/support/help/dynatrace-api/environment-api/oneagent-on-host"""
"""https://www.dynatrace.com/news/blog/improved-supportability-of-dynatrace-oneagent/"""

Re: How can I vizualize the host consumption per host?

Kenny_Gillette — Mon, 15 May 2023 10:39:24 GMT

Licensing dashboard at BizOps, which also gives other metrics like DEM and DDUs

https://dynatrace.github.io/BizOpsConfigurator/#deploy/all/Licensing%20Overview

Re: How can I vizualize the host consumption per host?

Viachaslau — Mon, 15 May 2023 10:48:05 GMT

Yeah, this is great - just imported
https://github.com/TechShady/Dynatrace-Dashboards/blob/master/Licensing%20Overview.json
all works OOB

Re: How can I vizualize the host consumption per host?

Theodore_x86 — Mon, 29 May 2023 21:22:22 GMT

Can you please explain how this formula produces the HU per host?

Re: How can I vizualize the host consumption per host?

dannemca — Tue, 30 May 2023 13:17:27 GMT

I don't know exactly, I just got the formula from the demo.live.dynatrace.com dashboard list and tested on my own env, and the numbers just matched.

Re: How can I vizualize the host consumption per host?

Theodore_x86 — Wed, 31 May 2023 12:40:17 GMT

Yeah, me too. It seems strange. It is a DDU metric and after a few divisions it concludes to the HU consumption. DT magic! 😛

Re: How can I vizualize the host consumption per host?

HJ — Wed, 31 May 2023 13:29:21 GMT

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.

Re: How can I vizualize the host consumption per host?

Georgi_Vuldzhev — Mon, 16 Dec 2024 17:30:02 GMT

Hello @Ahmed_Khaled

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?

Re: How can I vizualize the host consumption per host?

matthew_helliwe — Mon, 20 Jan 2025 11:37:50 GMT

In case anybody else in wondering the same thing, you get 1000 included metrics per host unit (see https://docs.dynatrace.com/docs/manage/monitoring-consumption-classic/davis-data-units/metric-cost-calculation). So if you divide the number of included metrics by 1000, you get the number of host units