SQL Monitor with Opsgenie Integration for alerts notification

himan

Hi All,

I am using SQL Monitor tool for our databases and would like to integrate it with Opsgenie for alerts notifications. I tried using webhook integration options but its not working. 
Has anyone is using or in the past have used opsgenie with SQL monitor for alert notifications and can share some advise on how to configure it?

squigley

Good afternoon!

We do not have written documentation for Opsgenie as we don't officially support it. However, we can at least point you in the right direction as we do have some customers already using it. Most of these users are using the SQL Monitor email notification to integrate with it.

 The following documentation, should be relevant although not specific to Opsgenie:

https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alert-notifications/setting-up-webhook-notifications

https://support.atlassian.com/opsgenie/docs/integrate-opsgenie-with-webhook/

From a brief search - this (third party, not ops genie) page goes through setting up the integration in opsgenie https://docs.meta-inf.hu/email-this-issue/v/email-this-issue-for-jira-server-data-center/documentation/administration/alerting-via-webhooks/webhooks/configuring-opsgenie-to-receive-webhooks

This page https://docs.opsgenie.com/docs/alert-api (the Create Alert section) has the format the webhook needs to be in in the example.

And this page https://docs.opsgenie.com/docs/authentication is how you would need to set the header in SQL Monitor to be able to authorize with Opsgenie to authenticate.

I hope this is of some help!