[Nagiosplug-devel] [ nagiosplug-Patches-3301066 ] check_mysql_query perfdata + smarter output

[SourceForge.net]

Patches item #3301066, was opened at 2011-05-12 17:16
Message generated for change (Tracker Item Submitted) made by psychoweb
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=3301066&group_id=29880

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Perf data
Group: release-1.4.15
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Paolo Serra (psychoweb)
Assigned to: Nobody/Anonymous (nobody)
Summary: check_mysql_query perfdata + smarter output

Initial Comment:
Added basic support for performance data. The MIN and MAX can be specified by submitting a query with two more columns as result. Either constants or other queries can be used as values.
A different string formatting allows automatical removal of trailing zeroes and decimal values, without ugly outputs such as "returned 6.000000".
Plus, the plugin now prints the query specification on the second line, thus shortening the output in Nagios web GUI. The first line is more straight-to-the-point and more readable. This is an example:

[input:]#check_mysql_query -H xxx -u xxx -p xxx -d nagios -q 'select count(*),10,100  from nagios_servicestatus as ss, nagios_services as s, nagios_hosts as h, nagios_objects as o where ss.service_object_id = s.service_object_id and s.service_object_id = o.object_id and s.host_object_id = h.host_object_id and ss.current_state = 2 and ss.scheduled_downtime_depth = 0' -c 3

[output:] QUERY CRITICAL: returned 6
'select count(*),10,100  from nagios_servicestatus as ss, nagios_services as s, nagios_hosts as h, nagios_objects as o where ss.service_object_id = s.service_object_id and s.service_object_id = o.object_id and s.host_object_id = h.host_object_id and ss.current_state = 2 and ss.scheduled_downtime_depth = 0'
| value=6;;;10;100

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=3301066&group_id=29880