[Nagiosplug-devel] Nagios SQLPlus query monitor?

[Litwin, Matthew]

Sure, that'd be fantastic! Please post it here or let me know a URL where I can scoop it up.

Thank you!

On Jan 12, 2010, at 1:39 PM, Helder Oliveira wrote:

> I have one from my own... if you want to try it i can provide you
> 
> On Tue, Jan 12, 2010 at 9:07 PM, Litwin, Matthew <mlitwin at stubhub.com> wrote:
>> Hello,
>> 
>> Similar to the check_oracle plugin I need a nagios plugin that will SQL from say a secondary text file and then report on the lines that it results. Ideally it would return the number of lines as output where WARN and CRITICAL conditions could be checked against, but also the actual rows would be listed as perfdata. Does any plugin like this exist?
>> 
>> I wrote a plugin that will use sqlplus to return a line count and report on those values in Perl, but honestly my scripting capabilities are pretty weak. If you are a Perl guy and see an elegant way of doing this, any guidance on this would be very helpful.
>> 
>> Thanks,
>> Matthew Litwin
>> mlitwin at stubhub.com
>> 415.222.8475
>> 
>> 
>> ------------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Verizon Developer Community
>> Take advantage of Verizon's best-in-class app development support
>> A streamlined, 14 day to market process makes app distribution fast and easy
>> Join now and get one step closer to millions of Verizon customers
>> http://p.sf.net/sfu/verizon-dev2dev
>> _______________________________________________________
>> Nagios Plugin Development Mailing List Nagiosplug-devel at lists.sourceforge.net
>> Unsubscribe at https://lists.sourceforge.net/lists/listinfo/nagiosplug-devel
>> ::: Please include plugins version (-v) and OS when reporting any issue.
>> ::: Messages without supporting info will risk being sent to /dev/null
>> 
> 
> ------------------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev 
> _______________________________________________________
> Nagios Plugin Development Mailing List Nagiosplug-devel at lists.sourceforge.net
> Unsubscribe at https://lists.sourceforge.net/lists/listinfo/nagiosplug-devel
> ::: Please include plugins version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null

Thanks,
Matthew Litwin
mlitwin at stubhub.com
415.222.8475