# How can I vizualize the host consumption per host?

**URL:** <https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704>\
**Category:** Open Q&A\
**Tags:** hosts-classic, licensing\
**Created:** [May 11, 2023, 6:07pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704 "2023-05-11T18:07:40Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![soportetr](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soportetr](https://community.dynatrace.com/u/soportetr)\
**Post date:** [May 11, 2023, 6:07pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/1 "2023-05-11T18:07:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dannemca](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dannemca/32/7215_2.png) [@dannemca](https://community.dynatrace.com/u/dannemca)\
**Post date:** [May 11, 2023, 6:52pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/2 "2023-05-11T18:52:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![soportetr](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soportetr](https://community.dynatrace.com/u/soportetr)\
**Post date:** [May 11, 2023, 7:26pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/3 "2023-05-11T19:26:53Z")

</div>

Hi&nbsp;[@dannemca](https://community.dynatrace.com/user/18264)

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

---

<div class="post-metadata">

**Author:** ![dannemca](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dannemca/32/7215_2.png) [@dannemca](https://community.dynatrace.com/u/dannemca)\
**Post date:** [May 11, 2023, 7:59pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/4 "2023-05-11T19:59:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Ahmed\_Khaled](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/ahmed_khaled/32/4595_2.png) [@Ahmed\_Khaled](https://community.dynatrace.com/u/Ahmed_Khaled)\
**Post date:** [May 15, 2023, 10:07am UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/5 "2023-05-15T10:07:48Z")

</div>

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:&nbsp;(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:&nbsp;(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)

---

<div class="post-metadata">

**Author:** ![Viachaslau](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@Viachaslau](https://community.dynatrace.com/u/Viachaslau)\
**Post date:** [May 15, 2023, 10:20am UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/6 "2023-05-15T10:20:25Z")

</div>

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…

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

```

---

<div class="post-metadata">

**Author:** ![Kenny\_Gillette](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/kenny_gillette/32/20170_2.png) [@Kenny\_Gillette](https://community.dynatrace.com/u/Kenny_Gillette)\
**Post date:** [May 15, 2023, 10:38am UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/7 "2023-05-15T10:38:16Z")

</div>

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

> **[BizOpsConfigurator](https://dynatrace.github.io/BizOpsConfigurator/#deploy/all/Licensing%20Overview)**

 ![Kenny_Gillette_0-1684147075923.png](https://global.discourse-cdn.com/dynatrace/original/2X/4/4401f1824b3bbd12da86e807e5b76167dec0200a.png)

---

<div class="post-metadata">

**Author:** ![Viachaslau](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@Viachaslau](https://community.dynatrace.com/u/Viachaslau)\
**Post date:** [May 15, 2023, 10:48am UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/8 "2023-05-15T10:48:05Z")

</div>

Yeah, this is great - just imported&nbsp;  
[https://github.com/TechShady/Dynatrace-Dashboards/blob/master/Licensing%20Overview.json](https://github.com/TechShady/Dynatrace-Dashboards/blob/master/Licensing%20Overview.json)  
all works OOB

---

<div class="post-metadata">

**Author:** ![Theodore\_x86](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/theodore_x86/32/17620_2.png) [@Theodore\_x86](https://community.dynatrace.com/u/Theodore_x86)\
**Post date:** [May 29, 2023, 9:22pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/9 "2023-05-29T21:22:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dannemca](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dannemca/32/7215_2.png) [@dannemca](https://community.dynatrace.com/u/dannemca)\
**Post date:** [May 30, 2023, 1:17pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/10 "2023-05-30T13:17:27Z")

</div>

I don’t know exactly, I just got the formula from the [demo.live.dynatrace.com](http://demo.live.dynatrace.com) dashboard list and tested on my own env, and the numbers just matched.

---

<div class="post-metadata">

**Author:** ![Theodore\_x86](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/theodore_x86/32/17620_2.png) [@Theodore\_x86](https://community.dynatrace.com/u/Theodore_x86)\
**Post date:** [May 31, 2023, 12:40pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/11 "2023-05-31T12:40:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![HJ](https://avatars.discourse-cdn.com/v4/letter/h/46a35a/32.png) [@HJ](https://community.dynatrace.com/u/HJ)\
**Post date:** [May 31, 2023, 1:28pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/12 "2023-05-31T13:28:14Z")

</div>

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&nbsp;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.

---

<div class="post-metadata">

**Author:** ![georgiv77](https://avatars.discourse-cdn.com/v4/letter/g/f475e1/32.png) [@georgiv77](https://community.dynatrace.com/u/georgiv77)\
**Post date:** [December 16, 2024, 4:58pm UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/13 "2024-12-16T16:58:47Z")

</div>

Hello [@Ahmed\_Khaled](https://community.dynatrace.com/user/60027)

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?

---

<div class="post-metadata">

**Author:** ![matthew\_helliwe](https://avatars.discourse-cdn.com/v4/letter/m/958977/32.png) [@matthew\_helliwe](https://community.dynatrace.com/u/matthew_helliwe)\
**Post date:** [January 20, 2025, 11:37am UTC](https://community.dynatrace.com/t/how-can-i-vizualize-the-host-consumption-per-host/39704/14 "2025-01-20T11:37:50Z")

</div>

In case anybody else in wondering the same thing, you get 1000 included metrics per host unit (see [DDUs for metrics — Dynatrace Docs](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
