AlertOps and SQL Monitor

AlertOps’ alert management system can be integrated with SQL Monitor to receive and respond to all (predefined status mappings) alerts through email, SMS, push notification or phone alerts. AlertOps would ensure that the alert/job status would reach the appropriate team by using proper workflows, escalation policies and schedules. Based on your ruleset, incidents can be automatically opened and closed, depending on what kind of alert SQL Monitor reports.

The above scenario and scope for integration is due to the fact that AlertOps has a very flexible and simple API/Webhook configuration feature that can be leveraged with SQL Monitor's alert and notification capabilities.

AlertOps - Inbound Integration

We can define rulesets in AlertOps so that SQL Monitor can send out alerts to the AlertOps platform. AlertOps would ensure based on these notifications received, that it would always reach out and assign to the correct person/team by utilizing its escalation policies, schedules, and workflow features.

AlertOps provides Inbound Integrations to integrate with numerous monitoring, chat and ITSM tools. You can configure an inbound integration for SQL Monitor.

At a high level this is how the flow looks like, you define an API integration in the AlertOps platform by defining settings like Integration Name, Escalation rules, recipient users/groups. Once an integration is defined, a unique API URL is generated. This acts as webhook or the gateway through which notifications from SQL Monitor reach AlertOps and thus an incident/alert is created correspondingly. The API can be defined with various settings like URL mappings, filters, escalations etc. as required. Redgate SQL Monitor has to be defined with a webhook notification channel, and this has to be associated with an alert policy.

Configure Inbound Integration in AlertOps

1. Navigate to Configuration àIntegrations àAdd API Integration à API Integration Detail page.
2. Select Redgate SQL Monitor.
3. Once you selected the integration, you can then specify basic settings like the integration name, escalation policy, names of the recipients/groups for which the alerts must be assigned to.
4. Once you click save, the API Integration will be created, and you will be given a unique URL which acts as the access point and needs to be configured at the source (in this case Redgate SQL Monitor), to send alerts. You can find the integration you just created, and you can give advanced settings and define various configurations for the alerts to be received and processed. For example, you can define when to open and close alerts based on the payload obtained from the API call, filters etc.
5. Make a note of the API URL, which will be used in Redgate SQL Monitor, so it calls a HTTP POST request to this URL with the body in JSON format containing the alert specific information. AlertOps automatically creates an alert when the status variable (statusChange) contains 'Raised'. The incident will also be closed automatically when the status 'Ended' is received from Redgate SQL Monitor.
6. In Advanced Settings you can define URL mappings as you want in the Rules for Opening and Closing Alerts. You can provide other filters and match with regex expressions as well. You can also test the generated URL with the sample data provided.

Configure Integration in Redgate SQL Monitor 

1. In your Redgate SQL Monitor portal, select the Configuration tab. Under 'Alerts and Metrics' select 'Notification Settings'
2. Select 'Webhook'
3. You can choose when you would want alerts to be sent to the webhook endpoint
4. Make sure that the 'Send webhook messages when alerts are raised' is enabled.
5. Under URL, paste the AlertOps Inbound Integration API URL
6. You can choose to send the default message payload. If you are planning to send a custom payload, make sure the fields are mapped accordingly in AlertOps Inbound Integrations.
7. Test. Save.
8. Make sure that on your Alert Settings page, when you configure the alert, specify the notification settings you want for that alert.

Thats it! You have configured a webhook notification method and associated it with an alert. Any alert will be sent to AlertOps for incident management.

Message logs, alert specific information can be viewed in the “Inbound Log” section in AlertOps Dashboard. Alerts can be viewed in the ‘Alerts’ tab as well.

Alert Triggering Information

AlertOps will automatically create an incident when a new alert is received from Redgate SQL Monitor when the statusChange contains "Raised".

If an alert with status "Raised" matches an existing Open Alert, AlertOps will recognize the new alert as a duplicate and ignore the alert.

The alert will be recorded in the Inbound Messages table as “Mapped Appended.”

AlertOps will automatically close the same incident when an alert with statusChange contains "Ended".

References

AlertOps Integration Guides

General Restful API Guide

Redgate SQL Monitor Guide