I get an error when I try to use the MSSQL Query Configuration Wizard. I've used other MSSQL wizards succeessfully. This is my 1st attempt with this wizard.
What is the version of Nagios XI that you are currently using? What about the version of the "check_mssql" plugin? Run the following command and show the output:
Do you have any special characters in the password, such as "$"? Let's see the output of the following commands, run from the command line on your Nagios XI server:
Try wrapping the password or/and the query in single quotes, instead of double to see if this is going to make a difference. Can you run a different query successfully? Is this the only query you are having issues with? Can you show us the query, run locally on the MSSQL server?
Be sure to check out our Knowledgebase for helpful articles and solutions!
I'm beginning to wonder if this wizard is appropriate for our needs. Let me try to explain what we'd like to accomplish.
1. Have a schedule SQL job scheduled to run once daily.
2. We like to trigger a warning if the job runs longer than 1 minute and receive a notification.
Is this the right check based on the above criteria?
How soon do you need to know if it's taking longer than a minute? You are currently checking every 5 minutes (with a max_check_attempts of 5). Perhaps a passive check would make more sense in this case?
Maybe you can come up with a custom (i.e.PowerShell) script, than can be called from Nagios XI via check_ncpa.py or check_nrpe, provided you have installed an agent on the server (NCPA or NSClient++).