Applies to: SQL Server (all supported versions)
Returns a row for every IP address that is associated with any Always On 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 GROUPTransact-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:
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.