Registration Table

SessionIdTime

datetime

Primary, Foreign

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table for more information.

SessionIdSeq

int

Primary, Foreign

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs Table for more information.

UserId

int

Foreign

The user ID. See the Users Table for more information.

EndpointId

uniqueidentifier

A GUID to identify a registration endpoint. Usually the register event from the same computer of the same user will have the same endpoint ID. Different machines have a different endpoint ID.

EndpointEra

uniqueIdentifier

ID used to differentiate registrations that involve the same user and the same endpoint.

This field was introduced in Microsoft Lync Server 2013.

ClientVersionId

int

Foreign

Client version of current user. See the ClientVersions Table for more information.

RegistrarId

int

Foreign

ID of the Registrar Server used for registration. See the Servers Table for more information.

PoolId

int

Foreign

ID of the pool in which the session was captured. See the Pools Table for more information.

EdgeServerId

int

Foreign

Edge Server the registration is going through. See the EdgeServers Table for more information.

IsInternal

Bit

Whether the user is logged on from internal or not.

IsUserServiceAvailable

bit

Whether the UserService is available or not.

IsPrimaryRegistrar

bit

Whether register to the primary Registrar or not.

IsPrimaryRegistrarCentral

bit

Indicates whether or not the user is registered with a survivable branch appliance.

This field was introduced in Microsoft Lync Server 2013.

RegisterTime

datetime

Registration time.

DeRegisterTime

datetime

De-Registration time.

ResponseCode

int

Response code of the register request.

DiagnosticId

int

Diagnostic ID of the register request. This indicates that diagnostic information type.

DeviceId

int

Foreign

The device that the register request is coming from. See the Devices Table for more information.

DeRegisterTypeId

tinyint

Foreign

The reason of de-register, such as ‘user initiated’, ‘registration expired’, ‘client fail’, and more. See the DeRegisterType Table for more information.

IPAddress

nvarchar(256)

IP address of the endpoint the user registered with. This can be an IPv4 address or an IPv6 address.

This field was introduced in Microsoft Lync Server 2013.