False Alert in Nagios XI

[akumarhe1868]

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

[scottwilkerson]

does this query return 2 sets of results?

Code: Select all

exec dbo.SpaceUsage 'xxxxdb','primary

Also, a stored procedure is usually passed with the -s

Code: Select all

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

[akumarhe1868]

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

[scottwilkerson]

Can you show what the output of this procedure is?

Code: Select all

exec dbo.SpaceUsage 'xxxxdb','primary'

[akumarhe1868]

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

[scottwilkerson]

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.

[akumarhe1868]

MSSQL returned 0 on query execution.

kindly suggest how to avoid false alert.

Thanks,
Anand

[scottwilkerson]

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?