Nagios Support Forum

Hi All,

I am receiving False alert in Nagios XI as below which is set to warning 75 on Query execution using MSSQL Query wizard.

WARNING: Query result 9 was higher than Query warning threshold 75.

Below is the command used:

--username xxxxxxxx --password "xxxxxx" --database master --port 1433 --query "exec dbo.SpaceUsage 'xxxxdb','primary'" -W 75 -C 90

Can anyone help me to correct the issue of false alert?

Much Appreciated.

Thanks,
Anand

does this query return 2 sets of results? Also, a stored procedure is usually passed with the -s

Code: Select all

-s, --storedproc    Optional stored procedure to execute on MSSQL server.

No, only one result comes for the query.

Do you want to add -s to the query along with -w -c ? if yes please tell me where this could be added.

Thanks,
Anand

Can you show what the output of this procedure is?

OK: Query duration=0.031215 seconds. Query result=59

akumarhe1868 wrote:OK: Query duration=0.031215 seconds. Query result=59

Sorry, I meant from within MSSQL

I'm trying to verify that there is just a single row and single column returned.

MSSQL returned 0 on query execution.

kindly suggest how to avoid false alert.

Thanks,
Anand

akumarhe1868 wrote:MSSQL returned 0 on query execution.

kindly suggest how to avoid false alert.

Thanks,
Anand

It just return 0? I'm not familiar with what this stored procedure does.

Can you get the same results with a standard query?