Forum Discussion

eitan1000's avatar
eitan1000
Copper Contributor
Feb 13, 2022

Findings all Azure SQL Servers with "Deny public network access" disabled

Hello,   I didn't find a way to find all the Azure "SQL Server" objects that has their check box of "Deny public network access" in the Firewall section - disabled.   I also tried the "Azure Reso...
pazdedav's avatar
pazdedav
Iron Contributor
Feb 17, 2022

Hi eitan1000 ,

 

If you want to search across many subscriptions, you could use Azure Resource Graph query instead of PowerShell (where you need to switch / loop between subscriptions):

 

resources
| where ['type'] =~ 'Microsoft.Sql/servers'
| where properties['publicNetworkAccess'] == 'Enabled'

Resources