Send Slack messages based on queries run against an SQL Server database.
Send Slack messages based on query results using a channel name and API token.
Variables
Credentials to use to access the SQL Server database.
SQL Steps to run. Last statement result can be multiple rows and columns. Result must have a 'sendalert' column that contains a value that is not NULL.
Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.
SQL steps to run after alerts are sent. Does not generate new alerts.
Parameters to use in your SQL Steps and Queries, if any. Refer to slide out help for more information.
Token to use to authenticate with the Slack workspace containing the channel to post in.
Channel to post the message in.
Message to post in the Slack channel. Results from the 'SQL Steps' can be included by column name. The entire set of results from the 'Detail Query' can be included in a code block using the variable 'detail_results_cb'.
Send Slack messages based on query results using an incoming webhook URL.
Variables
Credentials to use to access the SQL Server database.
SQL Steps to run. Last statement result can be multiple rows and columns. Result must have a 'sendalert' column that contains a value that is not NULL.
Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.
SQL steps to run after alerts are sent. Does not generate new alerts.
Parameters to use in your SQL Steps and Queries, if any. Refer to slide out help for more information.
Incoming webhook URL.
Message to post in the Slack channel. Results from the 'SQL Steps' can be included by column name. The entire set of results from the 'Detail Query' can be included in a code block using the variable 'detail_results_cb'.