mySQL Query

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
User avatar
costanza2k1
Posts: 197
Joined: Fri Aug 09, 2013 12:19 pm

mySQL Query

Post by costanza2k1 »

Hi all I have a question:

I'm running the mysql query and am looking for a critical alert when my return is 0. It should be a threshold alert. The query will either be a 1 or a 0... bad = 0, good = 1 :D This is what my query looks like:

Code: Select all

--hostname=aaa.aaa.com --port=1111 --username=blah--password="blah" --database=test--mode sql --name=...="Is  Bridge Up?" --c=0
Do you think I've set this up correctly, in particular the c = portion?
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: mySQL Query

Post by abrist »

Could you be a bit more specific? What is the full query? What table are you querying?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Locked