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.
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