< Back

Get-AzureRmSqlServerVirtualNetworkRule

Tue Jan 29, 2019 10:09 pm

NAME Get-AzureRmSqlServerVirtualNetworkRule



SYNOPSIS

Gets or lists Azure SQL Server Virtual Network Rule.





SYNTAX

Get-AzureRmSqlServerVirtualNetworkRule [-ResourceGroupName] <String> [-DefaultProfile <IAzureContextContainer>] -ServerName <String>

[-VirtualNetworkRuleName <String>] [<CommonParameters>]





DESCRIPTION

This command gets a specific Azure SQL Server Virtual Network Rule or a list of Azure SQL Server Virtual Network Rules under a server.





PARAMETERS

-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with azure



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-ResourceGroupName <String>

The name of the resource group.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

The Azure Sql Server name.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-VirtualNetworkRuleName <String>

The Azure Sql Server Virtual Network Rule name.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

System.String







OUTPUTS

Microsoft.Azure.Commands.Sql.VirtualNetworkRule.Model.AzureSqlServerVirtualNetworkRuleModel







NOTES









Example 1



PS C:\\> $virtualNetworkRule = Get-AzureRmSqlServerVirtualNetworkRule -ResourceGroupName rg -ServerName serverName -VirtualNetworkRuleName

virtualNetworkRuleName



Gets an single Azure SQL Server virtual network rule





Example 2



PS C:\\> $virtualNetworkRules = Get-AzureRmSqlServerVirtualNetworkRule -ResourceGroupName rg -ServerName serverName



Gets the list of Azure SQL Server virtual network rules under the specified server







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... etworkrule