Get-AzureRmSqlServerFirewallRule
Gets firewall rules for a SQL Database server.
Syntax
Get-AzureRmSqlServerFirewallRule
[-ResourceGroupName] <String>
[-ServerName] <String>
[[-FirewallRuleName] <String>]
[-Confirm]
[-WhatIf]
[<CommonParameters>]
Description
The Get-AzureRmSqlServerFirewallRule 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.
Examples
Example 1: Get all rules for a server
PS C:\>Get-AzureRmSqlServerFirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
ResourceGroupName : ResourceGroup01
ServerName : server01
StartIpAddress : 0.0.0.0
EndIpAddress : 0.0.0.0
FirewallRuleName : AllowAllWindowsAzureIps
ResourceGroupName : ResourceGroup01
ServerName : Server01
StartIpAddress : 1.2.3.4
EndIpAddress : 4.3.2.1
FirewallRuleName : Rule01
This command gets all the firewall rules for the server named Server01.
Required Parameters
-ResourceGroupName
Specifies the name of the resource group to which the SQL Server is assigned.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
-ServerName
Specifies the name of the SQL Server.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
Optional Parameters
-Confirm
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-FirewallRuleName
Specifies the name of the firewall rule.
| Type: | String |
| Aliases: | Name |
| Position: | 2 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Outputs
Microsoft.Azure.Commands.Sql.FirewallRule.Model.AzureSqlServerFirewallRuleModel