Service SQLAgent$MSSQLSERVER check_ncpa returning running$

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
imadc
Posts: 58
Joined: Wed Jun 14, 2017 12:10 pm

Service SQLAgent$MSSQLSERVER check_ncpa returning running$

Post by imadc »

In Nagios XI 5.4.7 and ncpa agents installed on SQL servers

We are using :check_xi_ncpa to check availability of SQL Services

$USER1$/check_ncpa.py -H $HOSTADDRESS$ $ARG1$

-M 'service/SQLAgent$MSSQLSERVER2012/running'
-M 'service/MSSQL$MSSQLSERVER2012/running'

Here is the result:

CRITICAL: SQLAgent$MSSQLSERVER2012 is running (should be running$)
CRITICAL: MSSQL$MSSQLSERVER2012 is running (should be running$)

Any ideas who resolve that using ncpa Agents check?
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Service SQLAgent$MSSQLSERVER check_ncpa returning runnin

Post by tgriep »

When a service has a $ in the name, they have to be treated differently than normal checks.
Try editing the argumeny and change it like the example below and let is know if it works.

Code: Select all

-M service/MSSQL$"$"MSSQLSERVER2012/running
Notice the extra "$" and that it does not have the single quotes.
Be sure to check out our Knowledgebase for helpful articles and solutions!
imadc
Posts: 58
Joined: Wed Jun 14, 2017 12:10 pm

Re: Service SQLAgent$MSSQLSERVER check_ncpa returning runnin

Post by imadc »

Thanks. That worked :)
We can close this thread now
bolson

Re: Service SQLAgent$MSSQLSERVER check_ncpa returning runnin

Post by bolson »

Closing topic as resolved.

Thank you for using the Nagios Support Forum.
Locked