check_mssql_sproc

Project Notes

From the Help file: Usage: check_mssql_sproc.pl -H HOSTNAME -p PROCEDURE -u user -P password -w -c check_mssql_sproc.pl 1.01 Copyright (c) 2005 Jeremy D. Pavleck This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. -p, --procedure Stored procedure to execute -H, --hostname Hostname of database server -d --database Database to run Stored Procedure against -u, --user SQL Username -P, --password SQL Password -c, --critical Value at which when met or exceeded will send a critical alert -w, --warning Value at which when met or exceeded (but is lower then critical value) will send a warning alert. -h, --help Display detailed help -v, --version Show version information This program will connect to a remote MS SQL server, execute a stored procedure, and then process the results to determine if there is an error state or not. Currently it only works if the stored procedure returns a single result in one column. It has not been tested to work with any other result sets; There is currently a sister script which DOES handle these things, as well as boolean and word results. It should be available shortly. Additional Notes & Tips: If you don't wish to have your SQL passwords exposed to the world you can do one of two things - 1. Set $USERx$ in resource.cfg to the password - this will be passed to the program by Nagios, but will not be visible from the web console or 2. If you have a universal SQL login for all of your Nagios queries, then you may hardcode the username & password into the beginning of this script.