performance / rrd graph values to CSV or Excel file

[zaji_nms]

Dear Expert

In the Performance Graph (rrd Graph), there is values at bottom (X-Axis), is there any way to export that in CSV or Excel format?

Our graph having name, Min , Avg , Max , Last , 95th Percentile (in/out) , can be export to excel?

Host, Service, Name In, Min In, Avg In, Max In, Last In, 95th In, Name Out, Min Out, Avg Out, Max Out, Last Out, 95th Out

Please see the graph attached and below values to be in Excel or if there is tool to export from WEB, http://server/nagiosxi
if not from Web/HTTP , anyway (tool) to export from Linux CLI.

Please note we just don't want single service, there will many in bulk, our customer asking their all services Utilization values in CSV or Excel.

MyHost, MyService, In (Mb_s), 0.020, 0.939, 14.520, .311, 3.06, Out(Mb_s), 0.051, 4.783, 30.285, 2.413, 20.50

Regards

[lmiltchev]

You can download a CSV file from the chat's context menu in the upper right corner, however you can do this only with hicharts. There is no option to do this with the RRD ("old" style charts). To show the hicharts in Nagios XI, go to Admin > System Config > System Settings > Theme & Display, select the Use Highcharts for Performance Graphs page and host/service detail pages (host/service popup graph always uses Highcharts) check-box, and click on "Update Settings".

[zaji_nms]

Dear lmiltchev

Currently we are very very comfortable with Classic / Standard RRD graph, we are happy , does want to do any changes.

Here we just do not want one or two or ten graphs values, we want in bulk, is there any way from HTTP or from Linux root# CLI tool ?

if output comes to Standard Output as Text, its okay to us, will try to manage....if any tool?

If No Tool, then very sad.......even though, can you please guide (maximum words / line), how to fetch.

I can do via/by rrdtool dump,fetch,graph but looks its to tedious....however anything from you as an expert sure will some guideline will help this moment or in future.

sometool hostname hostserver ds0 01-Jan-2019 01-Jan-2020 Label
sometool hostname hostserver ds0 01-Jan-2019 01-Jan-2020 Unit
sometool hostname hostserver ds0 01-Jan-2019 01-Jan-2020 MIN
sometool hostname hostserver ds0 01-Jan-2019 01-Jan-2020 AVG
sometool hostname hostserver ds0 01-Jan-2019 01-Jan-2020 MAX
sometool hostname hostserver ds0 01-Jan-2019 01-Jan-2020 95th
sometool hostname hostserver ds0 01-Jan-2019 01-Jan-2020 Bytes

sometool hostname hostserver ds1 01-Jan-2019 01-Jan-2020 Label
sometool hostname hostserver ds1 01-Jan-2019 01-Jan-2020 Unit
sometool hostname hostserver ds1 01-Jan-2019 01-Jan-2020 MIN
sometool hostname hostserver ds1 01-Jan-2019 01-Jan-2020 AVG
sometool hostname hostserver ds1 01-Jan-2019 01-Jan-2020 MAX
sometool hostname hostserver ds1 01-Jan-2019 01-Jan-2020 95th
sometool hostname hostserver ds1 01-Jan-2019 01-Jan-2020 Bytes

regards

[lmiltchev]

What you are looking for isn't implemented. You would need to create your own custom script to accomplish your goal. This is out of scope of Nagios support.