Page 4 of 4
Re: Check MS SQL Stored Procedure
Posted: Mon Sep 11, 2017 4:03 pm
by dwhitfield
@jkinning, did you have any other questions or are we ready to lock this up?
Re: Check MS SQL Stored Procedure
Posted: Wed Sep 13, 2017 7:39 am
by 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?
Re: Check MS SQL Stored Procedure
Posted: Wed Sep 13, 2017 1:34 pm
by 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.
Re: Check MS SQL Stored Procedure
Posted: Wed Sep 13, 2017 2:25 pm
by jkinning
Thanks. You can close this.
Re: Check MS SQL Stored Procedure
Posted: Wed Sep 13, 2017 2:27 pm
by scottwilkerson
Locking