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.