Skip to content

Get-AzSqlServerFirewallRule firewallrulename wildcard filtering returns all IP rules #16199

Closed
@DavidAtImpactCubed

Description

Description

The docs suggest that you can filter firewall rules with a prefix and a wildcard:
https://docs.microsoft.com/en-us/powershell/module/az.sql/get-azsqlserverfirewallrule?view=azps-6.5.0#example-2--get-all-rules-for-a-server-using-filtering

When using this syntax, all firewall rules are returned, even those that don't match the prefix.

Steps to reproduce

Get-AzSqlServerFirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -FirewallRuleName "Rule*"

Environment data

Name                           Value
----                           -----
PSVersion                      5.1.19041.1237
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.19041.1237
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

Metadata

Labels

CXP Attention[Deprecated] The Azure CXP Support Team is responsible for this issue.SQL - Managed Instancecustomer-reportedquestionThe issue doesn't require a change to the product in order to be resolved. Most issues start as that

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions