Page 1 of 1
access to basic nagios
Posted: Thu Jun 05, 2014 12:27 pm
by bursatec
nagios makes the reports about capacity plan within which only displays them in graphs. by business necessity occupy these data capacity planning.
What where that information is?
Can we query the database without losing the support nagios?
Re: access to basic nagios
Posted: Thu Jun 05, 2014 1:06 pm
by slansing
Can you give some more detail on what exactly you are looking for? With Naigos XI 2014, you can see the data that the report is displaying by clicking the "Table" icon next to your graph, under the cog wheel icon.
Re: access to basic nagios
Posted: Thu Jun 05, 2014 2:12 pm
by bursatec
to perform capacity planning of server generates a graph metric. that information is what we wanted to get in a relationship and so make a draw to measurement capabilities.
we could launch a query to the database to obtain the metric generated by the creation of the graph of capacity planning
Re: access to basic nagios
Posted: Thu Jun 05, 2014 2:52 pm
by jomann
It's not possible to query the database for this information because it is generated by special scripts but the API does exist... We do not have any documents on this because it's not that exposed.
If you query the capacity planning report like so (you'll need to change host/service/track)
Code: Select all
http://<xiserverip>/nagiosxi//includes/components/capacityplanning/cp-extrap.php?host=localhost&service=_HOST_&track=rta&options[method]=Holt-Winters&options[period]=1+week&cmd=extrapolate
You can also see the above query if you check the network requests in your browser when you load the capacity planning page if that helps you figure out what to use since each request changes depending on what you select... in the above you could change the period to more than one week or set the extrapolation method to be a different kind.
You can receive the data that would normally be displayed like so:
Code: Select all
adjusted_sigma: 0.009268591264412386
crit_level: 5000
dmax: 0.017677894736842104
dmean: 0.016890409356725092
edate: 1402601400
emax: 0.01727745723598277
emean: 0.016884676741326057
eslope: -1.863161245731063e-14
evalue: 0.016883849556669068
evalue_max: 0.016925165713865556
evalue_min: 0.01684253339947258
f_of_x_on_date: 0.016890386819926717
highcharts: [{pointStart:1400787000000, pointInterval:1800000, type:area, name:Observed,…},…]
integrity: 0.004457652303120341
nd: 672
ne: 336
residue: 0.00000114712069616591
sigma: 0.00004131615719648894
t_start: 1400787000
t_step: 1800
t_stop: 1402603200
unit: "ms"
warn_level: 3000
Re: access to basic nagios
Posted: Thu Jun 05, 2014 6:53 pm
by bursatec
for the same problem.
within the capacity planning tool is necessary to remove all information.
we have two options:
. 1 - can we create a user in the database to investigate where the information is located?
. 2 - which is the scope of the tool nagiosgraph; could be used to extract the information we need?
GREETINGS
Re: access to basic nagios
Posted: Fri Jun 06, 2014 9:36 am
by scottwilkerson
bursatec wrote:1 - can we create a user in the database to investigate where the information is located?
As jomann mentioned, it isn't in a database anywhere, it is calculated on the fly by Nagios XI and the RRD files that are located in /usr/local/nagios/share/perfdata
bursatec wrote:which is the scope of the tool nagiosgraph; could be used to extract the information we need?
As we don't produce nagiosgraph, I cannot speak to how you could collect this information for use in nagiosgraph.
jomann did give a bunch of info in this post
http://support.nagios.com/forum/viewtop ... 37#p101037
The bulk of the information in the graphs that you see would be found on this line
Code: Select all
highcharts: [{pointStart:1400787000000, pointInterval:1800000, type:area, name:Observed,…},…]
as for the integrating that into nagiosgraph, this is the glue you would need to create yourself.