Nagios Support Forum

how would you write a simple query when you go to configure tab > Monitor wizard > Oracle Query > enter the database credential > enter the default query? select count(*) from v\$session where status = "active" I know it must be something simple I am just having a hard time figuring it out...

But this is in the GUI not in the command line.

single ' around the the star '*' ?

Hello All, I wanted to know what are the escape special character when doing a query in Nagios Oracle_Query? for example select * from table_name i get an error saying OUTPUT: UNKNOWN - got no valid response for select \* from table_name - ORA-00911: invalid character (DBD ERROR: error possibly near...