Checking an MSSQL
Roy Sigurd Karlsbakk
roy at karlsbakk.net
Tue May 13 15:22:31 CEST 2003
...or try the check_mssql perl script I just sent to the list (also attached).
it's not so ugly as when using a shell script :)
On Tuesday 13 May 2003 15:01, Tom DE BLENDE wrote:
> Try the check_mssql.sh script in the contrib:
>
> http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/nagiosplug/nagiosplug/contri
>b/
>
> Ian Farr wrote:
> > Hello all,
> >
> > I would like to check an MS SQL 2000 database, and was wanting to know
> > if there are any people out there doing this already.
> >
> > I know I can check the NT service with NSClient, but I wanted to do
> > something a little more than that to make sure that the SQL service is
> > indeed accepting requests and processing them.
> >
> > My idea was to have an ODBC connection from the nagios box to the MS SQL
> > box and process the following:
> >
> > 1 - read data from a table
> > 2- write new data to a table
> > 3 - read the new data from a table to make sure that it worked
> > 4 - delete data from the table
> > 5 - read the table again to make sure that the data is gone.
> >
> > any ideas if something like this exists before I go down the road of
> > trying to create my own script with unix ODBC and all that???
> >
> > Thanks for the help..
> > ____________________
> > Ian Farr
> > Director of Network Infrastructure
> > Oceanwide.com
> > 514-289-9090 ext 234
>
> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> The only event dedicated to issues related to Linux enterprise solutions
> www.enterpriselinuxforum.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
--
Roy Sigurd Karlsbakk, Datavaktmester
ProntoTV AS - http://www.pronto.tv/
Tel: +47 9801 3356
Computers are like air conditioners.
They stop working when you open Windows.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_mssql
Type: application/x-perl
Size: 1786 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20030513/dd9426d4/attachment.bin>
More information about the Users
mailing list