Get-AzureSqlServerFirewallRule

Get-AzureSqlServerFirewallRule

Gets firewall rules for an Azure SQL Database server.

Syntax

Parameter Set: Default
Get-AzureSqlServerFirewallRule [-ResourceGroupName] <System.String> [-ServerName] <System.String> [[-FirewallRuleName] <System.String> ] [-Profile <Microsoft.Azure.Common.Authentication.Models.AzureProfile> ] 

Detailed Description

The Get-AzureSqlServerFirewallRule cmdlet gets firewall rules for an Azure SQL Database server. If you specify the name of a firewall rule, this cmdlet gets information about that specific firewall rule.

Parameters

-FirewallRuleName<System.String>

Specifies the name of the firewall rule that this cmdlet gets.

Aliases

none

Required?

false

Position?

3

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

-Profile<Microsoft.Azure.Common.Authentication.Models.AzureProfile>

Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ResourceGroupName<System.String>

Specifies the name of a resource group. This cmdlet gets firewall rules on a server in the resource group that this parameter specifies.

Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

-ServerName<System.String>

Specifies the name of a server. This cmdlet gets firewall rules from the server that this parameter specifies.

Aliases

none

Required?

true

Position?

2

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • System.String

Outputs

The output type is the type of the objects that the cmdlet emits.

  • System.Object

Notes

  • This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see about_CommonParameters.

Examples

Example 1: Get all rules for a server

This command gets all the firewall rules for the server named Server01.

PS C:\> Get-AzureSqlServerFirewallRule -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Azure SQL Database

New-AzureSqlServerFirewallRule

Remove-AzureSqlServerFirewallRule

Set-AzureSqlServerFirewallRule