Search found 2 matches

by katelee
Tue Mar 26, 2019 12:07 pm
Forum: Nagios XI
Topic: Nagios XI --Oracle query passing parameter
Replies: 1
Views: 67

Nagios XI --Oracle query passing parameter

I am using Oracle query connector to execute query on oracle database. I would like to make a use of the parameter. But the parameter is not being replaced with the value when executed from 'service". Please refer to screen shot attached. The service status is UNKNOWN since SQL cannot be execut...
by katelee
Tue Mar 26, 2019 11:57 am
Forum: Nagios XI
Topic: Passing argument to Oracle check_xi_oraclequery command
Replies: 1
Views: 422

Passing argument to Oracle check_xi_oraclequery command

I am trying to use $ARG2$ feature to pass parameter to my query. --connect 'host:1521/service' --username 'username' --password 'pwd' --mode sql --name="select max(round((total_mb - free_mb)/(total_mb)*100,0)) from sys.v_\$asm_diskgroup where name like '$ARG2$'" --warning 80 --critical 90 ...