How to Ignore Stopped Services

[jameyw]

In Nagios XI, I have a check that checks SQL Server on one of my servers. One this server, there are 4 SQL Server Services: SQL Full Text Filter Daemon Launcher, SQL Server, SQL Active Directory Helper Service, and SQL Server Agent. On this server, SQL Server, SQL Active Directory Helper Service is not running and therefore causes a critical alarm/notification. How can I configure the check to ignore this service?

Thanks

Jamey

[dwhitfield]

Is this a custom check or is this through the SQL Wizard? If it's a custom check, you'll just need to modify your script. If you post the script here, perhaps someone from the community can help you rewrite it. It probably makes sense to break it into 4 different checks, as it is checking 4 services.

Depending on your comfort level with XI, https://assets.nagios.com/downloads/nag ... gement.pdf may be of interest in setting all of this up.

[jameyw]

This is through the SQL Wizard. I'm pretty new at this but I'm not opposed to learning more.

[lmiltchev]

Have you tried dwhitfield's suggestion?

It probably makes sense to break it into 4 different checks, as it is checking 4 services.

[taandrews]

I am having the same issue with SQL services being monitored via WMI. XI finds 6 services, 5 OK and with with problems (0 excluded) This is the stock WMI wizard nothing custom.

[taandrews]

In my previous post "XI finds 6 services, 5 OK and with with problems (0 excluded) " . This is just for 1 process, the SQL Server. Apparently is has subprocesses associated with it. XI finds 6 services, 5 OK and with with problems (0 excluded) for the SQL Server process monitor

[tgriep]

If you are using the checkprocess mode for the check_wmi_plus plugin, you can setup an exclude for the command by addid a -3 string to exclude to the command.
Take a look at this link for more details on how to setup an exclude.
http://edcint.co.nz/checkwmiplus/?q=faq ... mmandlines

[taandrews]

I see now. Last time I checked I didnt see the reply. I thought because it was an old post, no one would see it. Thanks. I am using the check_xi_service_wmiplus command. Does your solution still apply.

[tgriep]

Yes, it should still apply.

[taandrews]

That did the trick! Thank you!