Check MS SQL Stored Procedure

[dwhitfield]

@jkinning, did you have any other questions or are we ready to lock this up?

[jkinning]

I think I am good but I can't figure out the critical part. The Business Unit must think I am a mind reader or understand their process and requirements because they are not much help at this point.

It would ideally be running the query as I have it written and if there are any records in the response, throwing an error and including the record text in the alert. Does that seem to be how this check behaves?

[scottwilkerson]

If you want to error on a quantity, you would usually craft you query to have an integer as a result, then set the "Result:" field to 0
Then you can set the warning and critical values to what you want.

There is no way with this plugin at present to return the results of the query or procedure however it has been asked for and may make it in as an option in future versions.

[jkinning]

Thanks. You can close this.

[scottwilkerson]

Locking