using check_oracle_health : How to get query result history

Frédéric GRANAT · Post by **Frédéric GRANAT** » Thu Sep 17, 2020 4:26 am

Hi,

I created a service like that :

source /usr/local/nagiosxi/etc/configwizards/oracle/oracle && $USER1$/check_oracle_health $ARG1$
$ARG1$ =
--connect 'xxxxxxxx:1523/Xxxxxxxx' --username 'xxxxxxx' --password 'xxxxxxx' --mode sql --name="select bytes/1024/1024 size_mo from dba_data_files where tablespace_name = 'CIVIROLB'" --warning 1000 --critical 2000

that service help me to monitor the tablespace growth in oracle
My service reached the critical limit and I would like to get my query result history (size_mo), particularly when there were big steps of growing.

How can I get that in NagiosXI ?

Frederic

ssax · Post by **ssax** » Thu Sep 17, 2020 5:13 pm

If the state never changed you would only see the data as plot points in the graphs (which is averaged).

If the state actually changed you would see the data in the Event Log and State History reports.

You can enable State Stalking on the host/service to log extra, see here:

https://assets.nagios.com/downloads/nag ... lking.html

That's about it other than querying the RRD through the API endpoint.

Frédéric GRANAT · Post by **Frédéric GRANAT** » Fri Sep 18, 2020 1:27 am

Hi,

Event Log and State don't meet my expectations (query value on a range of time).
Please see the attachment.
How can I do to get all the values ?

Post by **cdienger** » Fri Sep 18, 2020 5:23 pm

State stalking is the option you would want but it would need to have been enabled prior to the events.

Frédéric GRANAT · Post by **Frédéric GRANAT** » Mon Sep 28, 2020 2:23 am

Hi,
Thanks,
'State stalking is the option you would want but it would need to have been enabled prior to the events.'
How can I activate it ?

benjaminsmith · Post by **benjaminsmith** » Mon Sep 28, 2020 5:29 pm

Hi,

You can enable the stalking options for the host or service in the CCM under the alert settings tab.

stalking.png

Let us know if you have any other questions.

Frédéric GRANAT · Post by **Frédéric GRANAT** » Tue Sep 29, 2020 1:13 am

Thanks,
And the next time I will have an alert, where do I have to go in NagiosXI to see the query values ?

benjaminsmith · Post by **benjaminsmith** » Tue Sep 29, 2020 4:12 pm

Hi,

As Sean mentioned, you can check the Event Log or the State History Reports or if you want to look directly at the nagios.log, go to:

Code: Select all

/usr/local/nagios/var/nagios.log

Let us know if you have any other questions.

Regards,
Benjamin

Frédéric GRANAT · Post by **Frédéric GRANAT** » Thu Oct 01, 2020 9:46 am

Hi,

Thanks you can close the post.

Frederic

scottwilkerson · Post by **scottwilkerson** » Thu Oct 01, 2020 10:59 am

Frédéric GRANAT wrote:Hi,

Thanks you can close the post.

Frederic

Great!

Locking thread

Nagios Support Forum

using check_oracle_health : How to get query result history

using check_oracle_health : How to get query result history

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist

Re: using check_oracle_health : How to get query result hist