check_mssql

SQLServer

Write a Review

Description:

Allow you to run a stored procedure on an MSSQL server. Loosely based on the check_mssql plugin. Loops and output the data of all returned rows. Checks warnings, criticals and also allows to use columns fields as filters to the value name field. See example.

Current Version

0

Last Release Date

2014-12-12

Compatible With

Owner

Olivier Ragain

File	Description
check_mssql_sp_filter	the plugin

Allow you to run a stored procedure on an MSSQL server. Loosely based on the check_mssql plugin. Loops and output the data of all returned rows. Checks warnings, criticals and also allows to use columns fields as filters to the value name field. See example. Syntax for the procedure name: ' -U -P -s -d -w -c -f -i An example: check_mssql_sp -H 10.100.101.63 -U sa -P xxxXXXxxx -s 's_monitoring_queue_adv' -d itrans_igs_async -w 'queue=40;' -c 'queue=50;' -f 'queue_code' when using the -i arg, you can actually get the system to ignore some columns returned by the stored procedure Use at your own risks and please use stored procedure that don't do locks as much as possible :) A concrete example with the following dataset : header | network_code | throughput_in 1 | Telus B | 79 2 | Telus A | 39 3 | Others | 19 4 | NULL | 137 command: ./check_mssql_sp -H hostname -U user -P password -s storedproc -d database -f network_code result: OK - throughput_in_Telus_B=79,throughput_in_Telus_A=39,throughput_in_Others=19,throughput_in=137 |throughput_in_Telus_B=79,throughput_in_Telus_A=39,throughput_in_Others=19,throughput_in=137

You must be logged in to submit a review.

Your review has been submitted and is pending approval.

Your recommendation has been sent.

check_mssql_sp

Project Files

Project Notes

Add a Review

Thank you for your review!

Page Sections

Project Stats