Azure SQL Database
An Azure relational database service.
6,326 questions
Please read the following resources:
Can I send standard Azure SQL DB notifications as a webhook or access them via API without using `Alerts`?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 36%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
Tielman le Roux
1
Reputation point
Hi
I would like to get notified in a 3rd party app of all the standard notifications on my SQL DB resources. For example I want to know when I run out of resources.
I specifically do not want to setup Alerts on each SQL DB but would rather just make use of what appears to be default/existing Notifications that Azure are generating for me without having set up any Alerts.
Below is an example of a Notification that I would have wanted to send to a 3rd party system via Webhook (or polling some REST API from that 3rd party system) You will see this SQL DB has 3 Notifications, one of which is a std system generated Alert, and that is what I want to get access to.
Azure SQL Database
1 answer
Sort by: Most helpful
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator2022-04-07T16:32:45.26+00:00 -
Tielman le Roux 1 Reputation point
2022-04-07T16:44:57.097+00:00 @Alberto Morillo Thanks for the suggestions Alberto, but all of these require me to setup Alerts. I specifically do not want to setup any alerts and rather just want to know if I can access that standard Notification which is already generated for me
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
2022-04-07T16:58:34.17+00:00 To my knowledge you cannot do that with the stanadard notification you get. For advanced notifications like webhooks you need to use Azure Monitor that is intended for that.
-
Tielman le Roux 1 Reputation point
2022-04-07T17:00:08.343+00:00 Damn! I suspected as much, but was really hoping to get away with not having to do that. I mean the data is clearly already there, and Azure is already doing the monitoring, they just need to expose that data to me outside of the portal UI
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
2022-04-07T17:09:45.553+00:00 If they do that with some Azure products they will get to many apps/features to support all doing the same thing, and usally companies look for centralizing those notifications in one place. It all makes senses to MSFT and their enterprise customers.
As DBA consultant I usually only get access to Azure SQL Servers and do not get access to Azure Monitor, so I know what you mean and how it can benefit professionals in your situation or in my situation.
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
2022-04-07T17:17:15.62+00:00
Sign in to comment -