Notifications support for Microsoft Teams
Just like Slack (Webhook) notification support, it would be great if SQL Monitor could send notifications to Microsoft Teams.
Notifications can be sent to Microsoft Teams using Webhook notifications. See https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alert-notifications/setting-up-webhook-notifications/custom-webhook-messages for an example custom message to use for Microsoft Teams.
-
Nicky Murphy commented
I've got this working via a Logic App in Azure using the current webhook
-
Luke L commented
WorkAround. You can sent an alert to Teams by using the channel's Email address.
Right click on The Channel you want to use, select Get Email Address. Use that email address for SQL monitor to send emailed alerts.
-
kevriley commented
As a workaround, I'm using Flow to push notifications form email to Teams.
https://rileywaterhouse.co.uk/sql-monitor-alerts-in-microsoft-teams/ -
kevriley commented
Voted up.
In the meantime, has anyone found a workaround? i.e. notify slack -> notify teams, or notify snmp -> notify teams. -
Blaž Dakskobler commented
Also, having detailed options per alert (WHERE to send that specific alert) would be better than just having global settings, as is the case with Slack integration. That would allow for more fine tuning.
-
AJ Grant commented
Yep, I just voted up.