Azure SQL DB firewall traffic connection log, how to?

Question

I have an Azure SQL database and I have firewall rules on the database to allow certain IPs, where can I look for detailed logs to see if an IP source is getting blocked?

Answer 1

This entire subject is a web of lies.

Answer 2

You can use this article:

https://techcommunity.microsoft.com/t5/azure-observability/log-analytics-query-to-create-a-alert-for-ip-s-blocked-by/m-p/442819

Or you can use this different KQL query to find blocked IP addresses.

AzureDiagnostics
| where ResourceId == "<your-database-resource-id>"
| where Category == "FirewallRule"
| where Properties_s == "Blocked"
| project TimeGenerated, Resource, Properties