Problems Monitoring MsSql2000 db instances


#1

Hi All,

It seems like I’m unable to monitor sql 2000 db instances that contain a dollar sign in their name.
I’ve installed nsclient++ (or better known as nscp thesedays)

My service def looks somewhat like this:

define service{
use windows-service ; Name of service template to use
host_name hermes.ism
service_description Service: MSSQL$SQL2
check_command check_nt_win_srv!MSSQL$SQL2
}

command def:

‘check_nt_win_srv’ command definition

define command{
command_name check_nt_win_srv
command_line $USER1$/check_nt -H $HOSTADDRESS$ -p 12489 -v SERVICESTATE -l $ARG1$
}

Alright… so i know it fails right here: check_nt_win_srv!MSSQL**$**SQL2

I’ve tried the following combo’s:
check_nt_win_srv!'MSSQL$SQL2’
check_nt_win_srv!"MSSQL$SQL2"
check_nt_win_srv!'MSSQL$$SQL2’
check_nt_win_srv!MSSQL$$SQL2

None of these seem to work.

Anyone got an idea?


#2

i ran into same issue with a different process that had a space in it, if you look into the executable path of the service it will show you the .exe file for that service which is running under the processes. I went ahead and started monitoring the process instead of the service so when the process is killed the service is stopped…so far it’s worked fine and saved me twice…not sure if this would work for you but it’s worth a try…

Thanks,

Imran Nazir