Table of Contents

Class AvailabilitySchema.AvailabilityGroupListenerIpAddress

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.availability_group_listener_ip_addresses (Transact-SQL)

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


See sys.availability_group_listener_ip_addresses.

[Table(Schema = "sys", Name = "availability_group_listener_ip_addresses", IsView = true)]
public class AvailabilitySchema.AvailabilityGroupListenerIpAddress
Inheritance
AvailabilitySchema.AvailabilityGroupListenerIpAddress
Extension Methods

Properties

IPAddress

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

[Column("ip_address")]
[Nullable]
public string? IPAddress { get; set; }

Property Value

string

IpSubnetMask

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

NULL = IPv6 subnet

[Column("ip_subnet_mask")]
[Nullable]
public string? IpSubnetMask { get; set; }

Property Value

string

IsDHCP

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

[Column("is_dhcp")]
[NotNull]
public bool IsDHCP { get; set; }

Property Value

bool

ListenerID

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

[Column("listener_id")]
[Nullable]
public string? ListenerID { get; set; }

Property Value

string

NetworkSubnetIP

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

[Column("network_subnet_ip")]
[Nullable]
public string? NetworkSubnetIP { get; set; }

Property Value

string

NetworkSubnetIpv4Mask

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

[Column("network_subnet_ipv4_mask")]
[Nullable]
public string? NetworkSubnetIpv4Mask { get; set; }

Property Value

string

NetworkSubnetPrefixLength

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

[Column("network_subnet_prefix_length")]
[Nullable]
public int? NetworkSubnetPrefixLength { get; set; }

Property Value

int?

State

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.

[Column("state")]
[Nullable]
public byte? State { get; set; }

Property Value

byte?

StateDesc

Description of state, one of:

ONLINE

OFFLINE

ONLINE_PENDING

FAILED

[Column("state_desc")]
[Nullable]
public string? StateDesc { get; set; }

Property Value

string