Nagios Support Forum

Hi

Is there a plugin to monitor database query.

We would like to monintor a database query like the one below:

select count(*) from alloc_invn_dtl where stat_code = 11 and (sysdate - mod_date_time) * 24 * 60 > 30"

I am unsure what database you are talking about however Nagios Plugins has check_mysql_query which does require some pre-requisites to be installed as per https://support.nagios.com/kb/article.php?id=569.