Page 1 of 2

How to export all host disk information into CSV?

Posted: Thu Sep 30, 2021 8:22 am
by ITOPS_SPOC
Hello,

how to export Logical Disk information like Used, Free, Total for all disks available under each host in CSV file?

Thanks!

Re: How to export all host disk information into CSV?

Posted: Thu Sep 30, 2021 2:11 pm
by benjaminsmith
Hi,

Welcome to the Nagios Support Forum!

Just like clarify, did you want to export the historical data or the threshold settings for the service object?

Thanks,
Benjamin

Re: How to export all host disk information into CSV?

Posted: Fri Oct 01, 2021 1:51 am
by ITOPS_SPOC
HI Benjamin,
actually I would need both.

I am interested in data which I can see when I click Metrics in navigator and then select Metrics = Disk Usage.

Regards, Gregor

Re: How to export all host disk information into CSV?

Posted: Fri Oct 01, 2021 1:20 pm
by benjaminsmith
Hi Gregor,

For the configuration information, I would recommend using the following tool to export the nagiosql database data.

https://exchange.nagios.org/directory/U ... ol/details

For performance data, you can download that using the API ( see GET objects/rrdexport ) or the download link from the graph itself.
perfdata-download.png
Let us know if you need further assistance.

--Benjamin

Re: How to export all host disk information into CSV?

Posted: Mon Oct 04, 2021 2:11 am
by ITOPS_SPOC
Hi Benjamin,

this is not helpful to me. I want to export all Disk related data for all hosts at once. When I go to Metric navigator I do not see option to download data:
metric.jpg
One of options I can see is also using NCPA by running https://<hostname>:5693/api/disk/logical but again I have to run command for each host and then export data.


Another thing. I noticed when I create dashboard using metric data and availability. When I send this dashboard to email I see image blurred:
metric2.jpg
Regards,
Gregor

Re: How to export all host disk information into CSV?

Posted: Mon Oct 04, 2021 2:59 pm
by benjaminsmith
HI Gregor,

Right now, the Metrics Component doesn't have the option to bulk download perf data from a particular metric category. However, I can submit a feature request for that if you'd like.

Regarding the second issue, how long does it take to generate a PDF? Is this true just for the dashboard with Metric data coming in or are you seeing this across the reports?

I would recommend increasing the PHP defaults to allow for more memory and faster execution and then test this out once more.

Nagios XI - Optimizing The PHP Settings File

Best Regards,
Benjamin

Re: How to export all host disk information into CSV?

Posted: Tue Oct 05, 2021 8:55 am
by ITOPS_SPOC
Hi Benjamin,

yes, please raise enhancement request. How long does it take to accept and deliver this requirement?


For blurred report I have doubled and more values and reports comes same as before. I put in dashboard just for test only one Metric for disk usage, top 20 hosts.

Regards, Gregor

Re: How to export all host disk information into CSV?

Posted: Wed Oct 06, 2021 6:47 am
by ITOPS_SPOC
Hi Benjamin,

can you at least tell me how to get this data from DB directly?

I am interested in disk attributes like Used, Free, Total.

Regards, Gregor

Re: How to export all host disk information into CSV?

Posted: Wed Oct 06, 2021 9:26 am
by benjaminsmith
Hi Gregor,

The performance data is stored in separate RRD files found in the following directory.

Code: Select all

/usr/local/nagios/share/perfdata
You can export the data using RRDTool or use the API call (GET objects/rrdexport) to gather the data.

RRDTool
https://oss.oetiker.ch/rrdtool/doc/rrdxport.en.html


I put in a feature request. While I don't have any ETA or confirmation as to if the enhancement would be implemented. We are making big changes to how XI stores time-series data in version 6.0 and it will have more flexibility.

--Benjamin

Re: How to export all host disk information into CSV?

Posted: Wed Oct 06, 2021 9:38 am
by benjaminsmith
Hi,

For the PDF issue, what are the settings for PDF/JPEG Exporting in Admin > System Config > Performance Settings. Please try doubling the timeout from the default delay and let me know if there's any improvement.
pdf-export-settings.png
--Benjamin