How to export all host disk information into CSV?

[ITOPS_SPOC]

Hello,

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

Thanks!

[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

[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

[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

[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

[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

[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

[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

[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

[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