After upgrade, SQL check fails

[jpipitone]

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?

[jpipitone]

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!!!!!

[abrist]

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).

[jpipitone]

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

[abrist]

Will do.