Links

Redgate SQL Monitor

Steps to configure Redgate SQL Monitor integration for incident management, using Squadcast.
Redgate SQL Monitor is a database monitoring software used to easily monitor cloud or on-premises SQL-based databases.
Route detailed alerts from Redgate SQL Monitor to the right users in Squadcast.

Using Redgate SQL Monitor as an Alert Source

  1. 1.
    Navigate to Services -> Service Overview -> select or search for your Service. Expand the accordion -> In the Alert Sources section, click Add.
2. Select Redgate SQL Monitor. Copy the displayed Webhook URL to configure it within Redgate SQL Monitor. Finish by clicking Add Alert Source -> Done.
Important:
When an alert source turns Active, it’ll show up under Configured Alert Sources, you can either generate a test alert from the integration or wait for a real-time alert to be generated by the Alert Source. An Alert Source is active if there is a recorded incident via that Alert Source for the Service.

Create a Squadcast Webhook Alert in Redgate SQL Monitor

(1) Login to your Redgate SQL Monitor dashboard. Head over to the Configuration tab. Then under Alerts and Metrics, select Notification settings
(2) Scroll to the Webhook notifications section, and choose when a SQL Monitor should send messages to your Webhook
(3) You can choose to send the Default message itself by selecting the radio button. Paste the previously copied Squadcast Webhook URL in the placeholder for URL.
You can also click on Preview and test to test the alert. This will create a test incident in Squadcast.
That's it, you are good to go! Your Redgate SQL Monitor integration is now complete. Whenever Redgate SQL Monitor fires an alert with Status : Raised or Escalated, an incident will be created in Squadcast for it. Also, when an alert status has changed to Ended in Redgate SQL Monitor, the corresponding incident gets auto-resolved in Squadcast.
Last modified 27d ago