Modify Gauges in DB monitoring Nagios xi

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
levidaurric
Posts: 11
Joined: Mon Apr 19, 2021 10:18 am

Modify Gauges in DB monitoring Nagios xi

Post by levidaurric »

I am monitoring tablespace (Tablespace Free Space) on Nagios xi. The monitoring and the information is correct but I don't know how to modify the "Gauges" of the information.

I share my check command:
check_oracle_health --connect '172.27.203.xxx:xxx/****' --tablespace PSAPLIPSD --username '****' --password '****' --timeout 100 --mode tablespace-free --units GB --warning 19: --critical 15:




Regards
You do not have the required permissions to view the files attached to this post.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Modify Gauges in DB monitoring Nagios xi

Post by ssax »

I don't know if check_oracle_health supports it fully (when you pass --units GB it's only going to match against the GB size threshold) but this seemed to work to adjust the gauges:

Code: Select all

check_oracle_health --connect '172.27.203.xxx:xxx/****' --tablespace PSAPLIPSD --username '****' --password '****' --timeout 100 --mode tablespace-free --units GB --warning 10:,19: --critical 5:,15:
levidaurric
Posts: 11
Joined: Mon Apr 19, 2021 10:18 am

Re: Modify Gauges in DB monitoring Nagios xi

Post by levidaurric »

Set up a new service with recommended settings and the gauge looks the same.
The tachometer is shown the same, do you recommend using another plugin to monitor the tablespace?
You do not have the required permissions to view the files attached to this post.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Modify Gauges in DB monitoring Nagios xi

Post by ssax »

What does the Perfdata column show when viewing the service and clicking the + tab?
levidaurric
Posts: 11
Joined: Mon Apr 19, 2021 10:18 am

Re: Modify Gauges in DB monitoring Nagios xi

Post by levidaurric »

This is what is displayed ...
You do not have the required permissions to view the files attached to this post.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Modify Gauges in DB monitoring Nagios xi

Post by ssax »

Thanks, I'm looking for what is required and will post an update shortly, the plugin may not support it entirely and that's the best plugin to use.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Modify Gauges in DB monitoring Nagios xi

Post by ssax »

I can't get it to work with --units GB but this seems to work:

Code: Select all

check_oracle_health --connect '172.27.203.xxx:xxx/****' --tablespace PSAPLIPSD --username '****' --password '****' --timeout 100 --mode tablespace-free --units % --warning 90 --critical 95
You could do it with tablespace-usage as well:

Code: Select all

check_oracle_health --connect '172.27.203.xxx:xxx/****' --tablespace PSAPLIPSD --username '****' --password '****' --timeout 100 --mode tablespace-usage --warning 90 --critical 95
levidaurric
Posts: 11
Joined: Mon Apr 19, 2021 10:18 am

Re: Modify Gauges in DB monitoring Nagios xi

Post by levidaurric »

My problem was solved, thank you. :D :D
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Modify Gauges in DB monitoring Nagios xi

Post by ssax »

That's great to hear! Let us know when we're okay to lock this up and mark it as resolved.