Page 1 of 1

Exporting Capacity Planning Data

Posted: Mon Jun 20, 2016 3:57 pm
by awilson
HI. I saw an earlier question on this topic (https://support.nagios.com/forum/viewto ... y+planning.) The recommendation at that time was to highlight the displayed data tale and paste it into Excel.

We are looking to export the data directly. We have scripted performance data extracts using rrdtool, but it seems there must be a way that scales better. I've glanced at the source under /usr/local/nagiosxi/html/includes/components/capacityplanning and I'm wondering if there is a clear point where we can intercept the data for extract. Is that capability in your closed-source code or is the python code in the backend directory the best path to reach our goal? The capacity planning module is gathering the correct data, it makes more sense to leverage a working solution than to re-invent the wheel.

Thanks.

Re: Exporting Capacity Planning Data

Posted: Mon Jun 20, 2016 4:24 pm
by ssax
The closest you can get is with:

Code: Select all

http://YOURXISERVER/nagiosxi/includes/components/capacityplanning/cp-extrap.php?host=localhost&service=Current%20Load&track=load1&options[method]=Holt-Winters&options[period]=1%20year&cmd=extrapolate
http://YOURXISERVER/nagiosxi/includes/c ... b]HOSTNAME[/b]&service=SERVICEDESC&track=load1&options[method]=Holt-Winters&options[period]=PERIODFROMDROPDOWN&cmd=extrapolate

Accessing the capacity planning data via the API (and the ability to download via CSV) should be in the next minor version of XI (5.3.0), I'm unable to give an ETA though.

Re: Exporting Capacity Planning Data

Posted: Mon Jun 20, 2016 4:28 pm
by awilson
Thank you for the rapid reply.

Alan

Re: Exporting Capacity Planning Data

Posted: Mon Jun 20, 2016 4:31 pm
by ssax
No problem, the API is still relatively new so it'll be nice once more advanced features such as this are added.

Let us know if you have any questions.