MSSQL monitoring using MSSQL Query option

[chanlinux]

Hi Folks
We are using MSSQL Query option in Nagios console for Monitoring database alive state. But it expects Integer or string output from the Query. Is there any option to parse the query where-in output can be controlled with Custom message( Eg: Alert should be displayed as Database<name> is down).

Thanks

[hsmith]

What version of Nagios are you using, and what plugin are you using? Just want to get the basic information for starters.

[chanlinux]

i am are using nagios 5.x and default available plug-in as part of nagios installation

[rkennedy]

i am are using nagios 5.x and default available plug-in as part of nagios installation

There are actually a couple different plugins available.

But it expects Integer or string output from the Query. Is there any option to parse the query where-in output can be controlled with Custom message( Eg: Alert should be displayed as Database<name> is down).

Can you provide a screenshot to show us a bit more information?