There is the ODBC add-on that lets you check any type of DB using ODBC and accessing (doing a query) a table.
Dirk Bulinckx. Network Monitoring by Servers Alive - http://www.woodstone.nu DNS Hosting with ipv4 and ipv6 on http://www.stellardns.com From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On Behalf Of Demeulemeester, Pieter Sent: Friday, May 11, 2012 9:16 AM To: Servers Alive Discussion List Subject: RE: [SA-list] Ideas for new COM checks Hi Dirk, Maybe something for checking a SQL Database. I know you provided already the "Database (Microsoft SQL)" check, but that requires installation of DMO on the SQL servers (or SMO on SQL 2008 r2). Not always possible or desirable or ... We made a work around by installing the "native SQL client" and "SQLcmd.exe" on the SA server and created a CMD that does the same thing. Both files sqlncli.msi and SqlCmdLnUtils.msi downloadable from http://www.microsoft.com/download/en/details.aspx?id=16978 (http://www.microsoft.com/download/en/details.aspx?id=16978) . Then I added a "External (errorlevel)" check based on a CMD : ::Pieter Demeulemeester ::26/03/2012 ::Controleert de beschikbaarheid van een database op een SQL server :: :: %1 : servername or ip :: %2 : instancename :: %3 : databasename @echo on Set $SERVER=%1 Set $INSTANCE=%2 Set $DATABASE=%3 pushd "C:\Program Files\Microsoft SQL Server\100\Tools\Binn" sqlcmd.exe -l 60 -S TCP:%$SERVER%\%$INSTANCE% -d %$DATABASE% -q quit Set $RESULT=%ERRORLEVEL% popd exit /B %$RESULT% It works, but it would be easier (a nice-to-have feature) to have a built-in solution without the CMD. Kind regards, Pieter -----Original Message----- From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On Behalf Of Dirk Bulinckx Sent: dinsdag 24 april 2012 16:46 To: Servers Alive Discussion List Subject: [SA-list] Ideas for new COM checks We're looking for some good ideas for new COM checks for Servers Alive. If you have a specific checking need and it can't be done with Servers Alive, then please share that with us..and maybe we'll make a COM check for it :-) Dirk Bulinckx. Network Monitoring by Servers Alive - http://www.woodstone.nu (http://www.woodstone.nu) DNS Hosting with ipv4 and ipv6 on http://www.stellardns.com (http://www.stellardns.com) To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu (mailto:salive@woodstone.nu) If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. -------------------------------------------------------------------------------- Dit bericht wordt verzonden vanuit een e-mailadres voor professioneel gebruik. De verantwoordelijken binnen de organisatie kunnen kennis nemen van alle berichten verzonden naar dit adres. Le présent message est envoyé d'une adresse e-mail pour usage professionnel. Les responsables de l'organisation peuvent prendre connaissance de tous les messages envoyés à cette adresse. This message is sent from an e-mail address for professional use only. The persons in charge of the organisation may take note of all messages sent to this address. To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.
