I'm new to Idera and trying to configure alert responses. I want the response of a given alert to be run a SQL query and then send an email with the result of the query, however I'm not able to achieve that using the alert response interface. I can only run the sql script, but I don't have any option to provide the output on the send email action.
Is there any way to achieve this on the interface?
Can you write a Powershell script to do everything you describe?
There is a Powershell Alert Response Action available.