Page 1 of 1

Export Performance Data - Graphs (Historical)

Posted: Mon Oct 12, 2015 1:55 pm
by amit.ahuja
Hello,

We want to export the data in CSV format (historical) can some one guide me how can we do that -

Scenario - We are collection prod_firewall_interface_usage and i can see the performance graph there but want to export that in CSV format.

Thanks in Advance!!

Re: Export Performance Data - Graphs (Historical)

Posted: Mon Oct 12, 2015 3:17 pm
by jolson
The simplest way that I know of regarding exportation of performance data is to use the 'Capacity Planning' report. After running the report, click the 'data' button and review your CSV formatted data like so:
2015-10-07 11_46_44-Untitled 1 - LibreOffice Calc.png
As suggested, this data can be copied and pasted directly into an excel spreadsheet.

Please note that only XI 5+ will support the above solution.

Re: Export Performance Data - Graphs (Historical)

Posted: Mon Oct 12, 2015 5:31 pm
by amit.ahuja
Thanks, i do not see the button for data .. this is how it looks like

Please find attached.

Thanks

Re: Export Performance Data - Graphs (Historical)

Posted: Mon Oct 12, 2015 5:52 pm
by Box293
I have an alternate solution.

You could use this tool I created called the Performance Data Tool as this lets you see the raw data in the RRD files.

http://exchange.nagios.org/directory/Ad ... ol/details

Upload it into Nagios XI via Admin > System Extensions > Manage Components.

Then access it via the Tools menu.

When you click on an RRD it will open in a popup window with all the data in table which could be copied and pasted into Excel or similar.

Does this work for you?

Re: Export Performance Data - Graphs (Historical)

Posted: Tue Oct 13, 2015 12:40 pm
by amit.ahuja
Thank you this is what we needed - have passed these details to team who were looking for this data.
Waiting on feedback from them now.

Thanks much!!

Re: Export Performance Data - Graphs (Historical)

Posted: Tue Oct 13, 2015 12:59 pm
by jolson
Thanks, i do not see the button for data .. this is how it looks like
Are you running XI5+? The button you're looking for is only available on our newest version.
Waiting on feedback from them now.
Let us know what you find out. Thanks!


Jesse

Re: Export Performance Data - Graphs (Historical)

Posted: Wed Oct 14, 2015 10:55 am
by amit.ahuja
yeah we are not using Xi5 at this time - but the tool given by Box293 is helpful and we are good at this time.

Thanks Again!!

Re: Export Performance Data - Graphs (Historical)

Posted: Wed Oct 14, 2015 11:45 am
by rkennedy
Glad to see this tool worked for you. Feel free to open another thread if you need more assistance.