AzPolicyAdvertizer

last sync: 2025-May-01 19:36:43 UTC

Audit SQL Server firewall rule

Community Policy definition

Source Repository Community-Policy GitHub
JSON Community-Policy GitHub
Deploy policy 91130b0c-7c65-4569-9ed6-aaefb880427f (1.0.0) to Azure
Display name Audit SQL Server firewall rule
Id 91130b0c-7c65-4569-9ed6-aaefb880427f
Version 1.0.0
Details on versioning
Category SQL
Microsoft Learn
Description Audits the existence of a rule that enables traffic from a specific IP range to a SQL Server.
Mode All
Type Custom Community
Effect Default
AuditIfNotExists
Allowed
AuditIfNotExists, Disabled
RBAC role(s) none
Rule aliases THEN-ExistenceCondition (2)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.Sql/servers/firewallRules/endIpAddress Microsoft.Sql servers/firewallRules properties.endIpAddress True False
Microsoft.Sql/servers/firewallRules/startIpAddress Microsoft.Sql servers/firewallRules properties.startIpAddress True False
Rule resource types IF (1)
Microsoft.Sql/servers
JSON
EPAC
Deploy policy 91130b0c-7c65-4569-9ed6-aaefb880427f (1.0.0) to Azure