Nagios Support Forum

Prior to upgrading to Nagios 2014, I had a few SQL checks that verified the MSSQL service was started. These services are named instances, and are configured as follows:

check_xi_service_nsclient!!SERVICESTATE!-l MSSQL\\$$INST01 -d SHOWALL!!!!!

and

check_xi_service_nsclient!!SERVICESTATE!-l MSSQL\\$$INST02 -d SHOWALL!!!!!

After upgrading to NagiosXI 2014, NagiosXI reports:

Warning: MSSQL\: Error

Anything I'm missing?

I took out a slash and now the check works:

I changed this:

check_xi_service_nsclient!!SERVICESTATE!-l MSSQL\\$$INST01 -d SHOWALL!!!!!

To this:

check_xi_service_nsclient!!SERVICESTATE!-l MSSQL\$$INST01 -d SHOWALL!!!!!

I think this was already reported once as well. I have a suspicion that the syntax was ninja edited by Nick (as he was the maintainer of the plugin and performed a number of changes in this version). I can ask him when he is back in the office later this week (if I can find him, he is a ninja after all).

If you can spot the ninja when he gets back, let me know!

Thanks for the response - the check seem to be working now, just wanted to confirm that was the fix

Will do.