Registration Table

 

Topic Last Modified: 2010-12-14

Each record represents one user registration event.

Column Data Type Key/Index Details

SessionIdTime

datetime

Primary, Foreign

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. Reference to the Dialogs Table.

SessionIdSeq

int

Primary, Foreign

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. Reference to the Dialogs Table.

UserId

int

Foreign

The user ID. Reference to the Users Table.

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.

ClientVersionId

Int

Foreign

Client version of current user. Reference to the ClientVersions Table.

RegistrarId

Int

Foreign

ID of the Registrar Server used for registration. Reference to Servers Table.

PoolId

int

Foreign

ID of the pool in which the session was captured. Reference to Pools Table.

EdgeServerId

int

Foreign

Edge Server the registration is going through. Reference to the EdgeServers Table.

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.

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. Reference to the Devices Table.

DeRegisterTypeId

Tinyint

Foreign

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