Nagios Support Forum

Hi, in this case i need help about mysql.
I have passive check in a windows 7 with nrds and nagios XI.
1- I need to know the amount of registry in a table of mysql DB and if the amount is more than "80" report me critical, pls tell me what plugin i need to use and the command to type.

PLUS: If its possible, how to do that "if the amount of registry is more than 100 clear the table".

2- i need to check a value in the table, for example: If emp_id 4 and 10 are 35000 salary report ok, but if change salary report critical. Again pls tell me what plugin i need to use and the command to type.


Thx a lot!

I'm not finding any existing plugins for passive checks that do what you're looking for but you should be able to piece one together:

https://vwiki.co.uk/MySQL_and_PowerShell
https://assets.nagios.com/downloads/nag ... inapi.html
https://nagios-plugins.org/doc/guidelines.html

Let me know if you have any questions.

I read the links u send me, but i dont the knowledge to do that...

Many of the plugins are made by third-party developers. Since this is a Windows plugin, you might want to talk to the guys at http://nsclient.org/.

Of course, we can leave this open for community input.