Edit

Share via

Get-AzSqlServerIpv6FirewallRule

  • Reference
Module:
Az.Sql

Gets IPv6 firewall rules for a SQL Database server.

Syntax

PowerShell 
Get-AzSqlServerIpv6FirewallRule
   [[-Ipv6FirewallRuleName] <String>]
   [-ServerName] <String>
   [-ResourceGroupName] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

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

Examples

Example 1: Get all IPv6 rules for a server

PowerShell 
Get-AzSqlServerIpv6FirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01"

ResourceGroupName : ResourceGroup01
ServerName        : server01
StartIpv6Address    : 0000:0000:0000:0000:0000:ffff:0000:0000
EndIpv6Address      : 0000:0000:0000:0000:0000:ffff:0000:0001
Ipv6FirewallRuleName  : Rule01

ResourceGroupName : ResourceGroup01
ServerName        : Server01
StartIpv6Address    : 0000:0000:0000:0000:0000:ffff:0000:0002
EndIpv6Address      : 0000:0000:0000:0000:0000:ffff:0000:0003
Ipv6FirewallRuleName  : Rule02

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

Example 2: Get all IPv6 rules for a server using filtering

PowerShell 
Get-AzSqlServerIpv6FirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -Ipv6FirewallRuleName "Rule*"

ResourceGroupName : ResourceGroup01
ServerName        : server01
StartIpv6Address    : 0000:0000:0000:0000:0000:ffff:0000:0000
EndIpv6Address      : 0000:0000:0000:0000:0000:ffff:0000:0001
Ipv6FirewallRuleName  : Rule01

ResourceGroupName : ResourceGroup01
ServerName        : Server01
StartIpv6Address    : 0000:0000:0000:0000:0000:ffff:0000:0002
EndIpv6Address      : 0000:0000:0000:0000:0000:ffff:0000:0003
Ipv6FirewallRuleName  : Rule02

This command gets all the IPv6 firewall rules for the server named Server01 that start with "Rule".

Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:False
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-DefaultProfile

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

Type:IAzureContextContainer
Aliases:AzContext, AzureRmContext, AzureCredential
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Ipv6FirewallRuleName

Specifies the name of the IPv6 firewall rule.

Type:String
Aliases:Name
Position:2
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:True

-ResourceGroupName

Specifies the name of the resource group to which the SQL Server is assigned.

Type:String
Position:0
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-ServerName

Specifies the name of the SQL Server.

Type:String
Position:1
Default value:None
Required:True
Accept pipeline input:True
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
Required:False
Accept pipeline input:False
Accept wildcard characters:False

Inputs

Outputs