# Creating Table for Disk Usage using Visual Builder

**URL:** <https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491>\
**Category:** Kibana\
**Created:** [October 22, 2018, 10:18pm UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491 "2018-10-22T22:18:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![johncam](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@johncam](https://discuss.elastic.co/u/johncam)\
**Post date:** [October 22, 2018, 10:18pm UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/1 "2018-10-22T22:18:00Z")

</div>

I'm attempting to create a table visualisation to display disk usage for all logical volumes for all monitored servers. This will take the form of a row for each server with a column per logical volume.

5 volumes will be displayed, but not all servers will have all 5 volumes.

I've set up PerfMon counters for each of the 5 volumes in metricbeat.yml and am using 'perfmon.ignore\_non\_existent\_counters' to exclude any volumes that may not be present on a server.

However, I am only seeing percentages being displayed for those servers that have all 5 volumes.

Can anybody confirm if the ignore\_non\_existent\_counters is a working option under Metricbeat 6.2.4? Or do I need to upgrade to 6.3 to use this?

A basic table showing disk usage percentages in this way can't be that difficult surely, so please tell me I've completely missed the point somewhere ....

---

<div class="post-metadata">

**Author:** ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)\
**Post date:** [October 23, 2018, 2:30am UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/2 "2018-10-23T02:30:04Z")

</div>

I suggest switching to the Data Table visualization type and trying something like this:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/7/8736cc95e3ae93e82ec62aba8b57a8c95e23afe8.png)

---

<div class="post-metadata">

**Author:** ![johncam](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@johncam](https://discuss.elastic.co/u/johncam)\
**Post date:** [October 23, 2018, 11:03am UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/3 "2018-10-23T11:03:18Z")

</div>

Thanks for the feedback Spencer.

I've given that a go and have all values returned for C: which is correct as this volume is present on all servers.

However, also including the E: and F: drives that are only present on some servers, results in the data only being shown for those servers. Any server with one or more of these volumes unavailable does not return any data (see image).

 ![DiskUsageScreenshot](https://us1.discourse-cdn.com/elastic/original/3X/d/9/d97f03a659a6efd57bf3de2a58ef33530009bd5f.png)

This is why I am wondering if the IGNORE\_NON\_EXISTENT counters option is not being recognised.

Are there any other possible reasons for disappearance of data under these circumstances?

Kind Regards

---

<div class="post-metadata">

**Author:** ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)\
**Post date:** [October 23, 2018, 12:47pm UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/4 "2018-10-23T12:47:55Z")

</div>

> [@johncam](#):
>
> I've given that a go and have all values returned for C: which is correct as this volume is present on all servers.
> 
> However, also including the E: and F: drives that are only present on some servers, results in the data only being shown for those servers.

It sounds like when you add the columns for e and f to your visualization you get different data, which makes me think it's not a beats problem but something based on the way Kibana is querying...

---

<div class="post-metadata">

**Author:** ![johncam](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@johncam](https://discuss.elastic.co/u/johncam)\
**Post date:** [October 23, 2018, 4:11pm UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/5 "2018-10-23T16:11:18Z")

</div>

There's definitely something amiss somewhere, as I'm seeing a similar problem when using other perfmon counters.

For example, the following entry in metricbeat.yml is correct as far as I and the config test are concerned, but I fail to see any values returned. I only have this running on one server at present and Kibana identifies with ony this single server.

- instance\_label: Process.PoolPaged.Bytes  
instance\_name: Process  
measurement\_label: PoolPaged.Bytes  
query: '\\machinename\process(listen)\pool paged bytes'

Are there any known issues in Kibana that would exhibit this sort of behaviour?

Kind Regards

---

<div class="post-metadata">

**Author:** ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)\
**Post date:** [October 23, 2018, 7:18pm UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/6 "2018-10-23T19:18:10Z")

</div>

There are a lot of reports and I'm not sure if someone has reported something similar to this, but you can search around the forums and [https://github.com/elastic/kibana/issues](https://github.com/elastic/kibana/issues) and see if you find anything that sounds similar.

---

<div class="post-metadata">

**Author:** ![johncam](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@johncam](https://discuss.elastic.co/u/johncam)\
**Post date:** [October 24, 2018, 10:05am UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/7 "2018-10-24T10:05:11Z")

</div>

Thanks Spencer

Whilst I have the opportunity to do so, I'm going to uplift everything to V6.4.2 in any case.

I'll run through this again once I've done so and let you know what happens.

---

<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:** [November 21, 2018, 10:05am UTC](https://discuss.elastic.co/t/creating-table-for-disk-usage-using-visual-builder/153491/8 "2018-11-21T10:05:12Z")

</div>

Closed on November 21, 2018, 10:05am UTC

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