Cmdlets

Choose a cmdlet from the list on the left or search for a specific cmdlet. Choose a cmdlet from the list or search for a specific cmdlet.
About Help  Providers
 

Get-AzureSqlDatabaseServerFirewallRule

Get-AzureSqlDatabaseServerFirewallRule

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

Returns firewall rules in the specified Azure SQL Database Server in the current subscription.

Syntax

Get-AzureSqlDatabaseServerFirewallRule [-ServerName] [-RuleName] [<CommonParameters>]

Detailed Description

If a firewall rule name is specified in the RuleName parameter, the cmdlet returns information about the specific firewall rule. Otherwise, information about all the firewall rules in the specified SQL Database Server is listed.

Parameters

-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

0

Default value

None

Accept pipeline input?

true (ByPropertyName)

Accept wildcard characters?

false

-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

Input Type

Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerFirewallRuleContext

Return Type

IEnumerable<Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerFirewallRuleContext>

Notes

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"

New-AzureSqlDatabaseServerFirewallRule
Remove-AzureSqlDatabaseServerFirewallRule
Set-AzureSqlDatabaseServerFirewallRule