check_db_record_count

Project Notes

nagios plugin to check if a query returns a specific count based on a sql query within a specific timeframe author: Sergei Haramundanis 24-Oct-2006 usage: check_db_record_count access_file check_from_time check_to_time query_file max_count Description: This plugin will check if a query exceeds a specific count (max_count) at a specific timeframe specified by check_from_time and check_to_time (in HHMM format) by executing the specified sql query in the query_file This plugin requires oracle sqlplus (see definition of ORACLE_HOME, PATH and LD_LIBRARY_PATH further on in this script, you may need to change them) all fields are required contents of access_file must contain database connection information in the following format: USERNAME username PASSWORD password CONNECTION_STRING connection_string contents of query_file must contain sql query information in the following format: SQL_QUERY specific_sql_query these are to be used by sqlplus to login to the database and execute the appropriate sql query Output: During any run of the plugin, the value returned will be as follows: if the current time is within the specified timeframe, it will execute the specific sql query if max_count is exceeded it will return a CRITICAL state with the message: [CRITICAL] detected n records (max_count # exceeded) if max_count is not exceeded it will return an OK state with the message: [OK] detected n record(s) (max_count # not exceeded) if the current time is outside the specified timeframe it will return an OK state with the message: [OK] current time outside of monitoring timeframe check_from_time and check_to_time 24-Apr-2007 version 2.1 update includes: 1. support for reporting remedial action 2. exclude running on weekends and holidays