Nsclient 4.3
Windows 2012 R2
SQL 2014
Using a SQL plugin to check the SQL database sizes. I posted this question earlier and we got most of the databases working. I have a new issue I would like help on.
Nagios show this
SQLDBSIZE-Managed Metadata Service OK 11-11-2018 00:19:17 0d 21h 36m 37s 1/10 C:Program FilesNSClient++scriptscheck_sqldbsize.vbs(24, 15) Microsoft VBScript runtime error: Type mismatch: 'cint'
I run the same on the server
root@tgcs017:/usr/local/nagios/etc/objects/windowsservers# /usr/lib/nagios/plugins/check_nrpe -t 50 -H 'TGCS014-N1' -c check_sqldbsize -a 'TGCS014-N1-SQLS\Sharepoint!Managed Metadata Service_addd35ce8f5049a69f66716abf5879a0!8000!9500'
Code: Select all
define service {
host_name hostname
service_description SQLDBSIZE-Managed Metadata Service
check_command check_sqldbsize!'TGCS014-N1-SQLS\Sharepoint!Managed Metadata Service_addd35ce8f5049a69f66716abf5879a0!8000!9500'
check_interval 1440
notification_interval 1440
servicegroups SQL DB Size
check_period backup_period
notification_period backup_period
use generic-service
}
Code: Select all
define command {
command_name check_sqldbsize
command_line $USER1$/check_nrpe -H $HOSTADDRESS$ -t 120 -c check_sqldbsize -a $ARG1$ $ARG2$ $ARG3$ $ARG4$
}
The ONLY difference I found is that the Databases names have a space between them all the databases that are working do not have a space in the name.
I tried place "" around extra '' no luck.
Any ideas
Thank you
Tom