SQLServer

check_mssql_sp

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

Copy Page Link Recommend Contact Owner Login to Add to Favorites Login to Claim
Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Download Now

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
Project Files
FileDescription
check_mssql_sp_filter

the plugin

Project Notes
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
Reviews (0) Add a Review
Page Sections
Project Overview Project Files Project Notes Reviews
Project Stats
Rating
0 (0)
Favorites
0
Views
14,546