Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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 |
Security
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.