Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.availability_group_listener_ip_addresses (Transact-SQL)

SQL Server 2012

Returns a row for every IP address that is associated with any AlwaysOn availability group listener in the Windows Server Failover Clustering (WSFC) cluster.

Primary key:  listener_id + ip_address + ip_sub_mask

Column name

Data type

Description

listener_id

nvarchar(36)

Resource GUID from Windows Server Failover Clustering (WSFC) cluster.

ip_address

nvarchar(48)

Configured virtual IP address of the availability group listener. Returns a single IPv4 or IPv6 address.

ip_subnet_mask

nvarchar(15)

Configured IP subnet mask for the IPv4 address, if any, that is configured for the availability group listener.

NULL = IPv6 subnet

is_dhcp

bit

Whether the IP address is configured by DHCP, one of:

0 = IP address is not configured by DHCP.

1 = IP address is configured by DHCP

network_subnet_ip

nvarchar(48)

Network subnet IP address that specifies the subnet to which the IP address belongs.

network_subnet_prefix_length

int

Network subnet prefix length of the subnet to which the IP address belongs.

network_subnet_ipv4_mask

nvarchar(45)

Network subnet mask of the subnet to which the IP address belongs. network_subnet_ipv4_mask to specify the DHCP <network_subnet_option> options in a WITH DHCP clause of the CREATE AVAILABILITY GROUP or ALTER AVAILABILITY GROUP Transact-SQL statement.

NULL = IPv6 subnet

state

tinyint

IP resource ONLINE/OFFLINE state from the WSFC cluster, one of:

1 = Online. IP resource is online.

0 = Offline. IP resource is offline.

2 = Online Pending. IP resource is offline but is being brought online.

3 = Failed. IP resource was being brought online but failed.

state_desc

nvarchar(60)

Description of state, one of:

ONLINE

OFFLINE

ONLINE_PENDING

FAILED

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.