# Unique count of host based on system cpu pct and system memory pct

**URL:** <https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770>\
**Category:** Kibana\
**Created:** [December 13, 2019, 9:29am UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770 "2019-12-13T09:29:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![aparnababu](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@aparnababu](https://discuss.elastic.co/u/aparnababu)\
**Post date:** [December 13, 2019, 9:29am UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770/1 "2019-12-13T09:29:03Z")

</div>

i want to classify the server as healthy,warning and bad health server based on range.Suppose if my system.cpu.used.pct and system.memory.actual.used.pct is \<40 then it falls under healthy server if it falls between 40 to 60 den warning server status if above 60 bad server status. how do i filter these two fields n get the unique count

---

<div class="post-metadata">

**Author:** ![aparnababu](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@aparnababu](https://discuss.elastic.co/u/aparnababu)\
**Post date:** [December 13, 2019, 9:59am UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770/2 "2019-12-13T09:59:04Z")

</div>

how to find the unique count of host whose system.cpu.used.pct and system.memory.actual.used.pct \< 40

---

<div class="post-metadata">

**Author:** ![aparnababu](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@aparnababu](https://discuss.elastic.co/u/aparnababu)\
**Post date:** [December 16, 2019, 5:12am UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770/3 "2019-12-16T05:12:02Z")

</div>

is there any update??

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [December 16, 2019, 10:56pm UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770/4 "2019-12-16T22:56:25Z")

</div>

Hey @aparnababu, you can use a metric visualization configured similar to the following:

 ![Screen Shot 2019-12-16 at 2.55.53 PM](https://us1.discourse-cdn.com/elastic/original/3X/f/2/f273ce61b89c49e24cee36e836b9f6b2aa285346.png)

---

<div class="post-metadata">

**Author:** ![aparnababu](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@aparnababu](https://discuss.elastic.co/u/aparnababu)\
**Post date:** [December 17, 2019, 9:38am UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770/5 "2019-12-17T09:38:56Z")

</div>

i would like to compare both system.cpu.user.pct and system.memory.actual.pct and get the server status. is there any possibility to use two fields (system.cpu.user.pct and system.memory.actual.pct) in same visualization and get the server status?

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [December 17, 2019, 2:32pm UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770/6 "2019-12-17T14:32:29Z")

</div>

Hey @aparnababu, yes you can. You can change use `system.cpu.user.pct < 40 and system.memory.actual.pct < 40` for the filter.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 14, 2020, 2:32pm UTC](https://discuss.elastic.co/t/unique-count-of-host-based-on-system-cpu-pct-and-system-memory-pct/211770/7 "2020-01-14T14:32:31Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
