Nagios Support Forum

so I've created a new sql alarm. This alarm runs a query against an oracle database and returns a value. If the value is greater than Zero then it should alarm, letting us know there is an issue with what's called a concurrent manager in Oracle. The problem I had with the alarm is that the value that was returned was 0.132, which did not trigger my alarm. Correct me if i'm wrong here, but it seems as though Nagios is looking for whole number values only?? that may be incorrect however we did not get an alarm that the concurrent manager was down. Is there a way to have nagios alarm if the value is any number (even a decimal point) above zero?

thanks!

here's my query:
--connect '<database>:<port>/<sid>' --username '<username>' --password '<password>' --mode sql --name="select count (*) from ( select q.concurrent_queue_name, q.running_processes actual, q.max_processes target from applsys.fnd_concurrent_requests r, applsys.fnd_concurrent_processes p, applsys.fnd_concurrent_queues q where q.ENABLED_FLAG='Y' and q.TARGET_PROCESSES <> 0 and q.TARGET_PROCESSES <> q.RUNNING_PROCESSES and (q.RUNNING_PROCESSES/q.TARGET_PROCESSES)*100 < 50 and q.CONTROL_CODE in ('U', 'W', 'X', 'S', 'T', 'D', 'E') and q.CONCURRENT_QUEUE_NAME<>'FNDSM_AUTHENTICATION' and r.controlling_manager (+) = p.concurrent_process_id and p.queue_application_id = q.application_id and p.concurrent_queue_id = q.concurrent_queue_id group by q.concurrent_queue_name, target_node, q.running_processes, q.max_processes)" --critical 0

Was your check created by one of our "default" wizards that ship with XI? What is the plugin that you are using?

Please show us the actual command run from the command line, along with the output of it.