Checking MSSQL Server via ODBC Connection

[Quillen, Channon]

I use unixODBC and sqsh (http://www.sqsh.org/) to run select statements against a MS SQL database.  I wrote a custom script with these apps to run in Nagios.
-Channon 
________________________________________
From: nagios-users-admin at lists.sourceforge.net [mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Sand Philipp
Sent: Tuesday, July 13, 2004 12:21 AM
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] Checking MSSQL Server via ODBC Connection

Hello list, 
I got some ODBC Clients for Linux, and want to do some checks on an MSSQL Server via these ODBC Connections. These checks are basically some selects on the databse to look for deadlocks etc... I want to run those checks from the Nagios Server, so I don't have to install a client or so on the MSSQL Server.
Has anyone done this before, or does anyone have a plugin or a solution already prepared? 
Thanks in advance, 
Philipp 

_____________________________ 
Philipp Sand 
OC-CC-TEC-SYS 
SYCOR GmbH 
Heinrich-von-Stephan-Straße 1-5 
D - 37073 Göttingen 
Telefon +49 (0) 551 / 490 - 0 
Telefax +49 (0) 551 / 490 - 2000 
philipp.sand at sycor.de 
www.sycor.de 
------------------------------------------------ 


************************************************

sycor plastics - die neue Branchenlösung für die Kunststoffindustrie

www.sycor-plastics.de

************************************************




Diese E-Mail ist vertraulich und kann darüber hinaus persönliche Informationen beinhalten. Wenn Sie nicht der bestimmungsgemäße Empfänger sind, löschen Sie bitte die E-Mail und deren Anhänge sofort und benachrichtigen Sie uns darüber. Die Firma sycor willigt in keine Verträge oder vertragliche Verpflichtungen ein oder übermittelt rechtsverbindliche Angebote, die in Form von E-Mail versandt werden, sofern dies nicht ausdrücklich in schriftlicher Form zwischen den Parteien vereinbart wurde.

This e-mail is confidential and may contain personal and/or privileged information. If you are not the intended recipient please delete this e-mail and all attachments immediately and inform us. The company sycor does not agree with contracts or contract obligations sent by e-mail, neither do we transmit legally binding offers by e-mail, unless this is not expressly agreed upon between the parties and documented in written form.




-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
digital self defense, top technical experts, no vendor pitches, 
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null