Get-AzureSqlDatabaseServerFirewallRule
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
Get-AzureSqlDatabaseServerFirewallRule
Returns firewall rules in the specified SQL Database server in the current subscription.
Syntax
Parameter Set: Default
Get-AzureSqlDatabaseServerFirewallRule [-ServerName] <String> [-RuleName <String> ] [ <CommonParameters>]
Detailed Description
The Get-AzureSqlDatabaseServerFirewallRule cmdlet retrieves firewall rules from the specified SQL Database server in the current subscription. If a firewall rule name is specified in the RuleName parameter, it returns information about the specific firewall rule. Else, information about all the firewall rules in the specified SQL Database server is listed.
Parameters
-RuleName<String>
The name of the firewall rule to retrieve. If not specified, information about all the firewall rules in the specified SQL Database server is listed.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
-ServerName<String>
The name of the SQL Database server for which you want to retrieve the firewall rules. Specify only the server name, and not the fully qualified DNS name.
Aliases |
none |
Required? |
true |
Position? |
1 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
Outputs
The output type is the type of the objects that the cmdlet emits.
- IEnumerable<SqlDatabaseFirewallRuleContext>
Examples
-------------- Example 1 --------------
This command returns all the firewall rules in the specified SQL Database server (“lpqd0zbr8y”).
PS C:\> Get-AzureSqlDatabaseServerFirewallRule –ServerName "lpqd0zbr8y"
-------------- Example 2 --------------
This command returns the specified firewall rule (“myRule”) in the specified SQL Database server (“lpqd0zbr8y”).
PS C:\> Get-AzureSqlDatabaseServerFirewallRule –ServerName "lpqd0zbr8y" -RuleName "myRule"
Related topics
New-AzureSqlDatabaseServerFirewallRule