Registration table
Each record represents one user registration event.
Column | Data Type | Key/Index | Details |
---|---|---|---|
SessionIdTime |
datetime |
Primary, Foreign |
Time of session request. Used with SessionIdSeq to uniquely identify a session. For more information, see the Dialogs table in Skype for Business Server 2015. |
SessionIdSeq |
int |
Primary, Foreign |
ID number to identify the session. Used with SessionIdTime to uniquely identify a session. For more information, see the Dialogs table in Skype for Business Server 2015. |
UserId |
int |
Foreign |
The user ID. For more information, see the Users table. |
EndpointId |
uniqueidentifier |
A GUID to identify a registration endpoint. Usually the register event from the same computer of the same user has 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. For more information, see the ClientVersions table in Skype for Business Server 2015. |
RegistrarId |
int |
Foreign |
ID of the Registrar Server used for registration. For more information, see the Servers table. |
PoolId |
int |
Foreign |
ID of the pool in which the session was captured. For more information, see the Pools table. |
EdgeServerId |
int |
Foreign |
Edge Server the registration is going through. For more information, see the EdgeServers table in Skype for Business Server 2015. |
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. For more information, see the Devices table in Skype for Business Server 2015. |
DeRegisterTypeId |
tinyint |
Foreign |
The reason of deregister, such as 'user initiated,' 'registration expired,' 'client fail,' and more. For more information, see the DeRegisterType table in Skype for Business Server 2015. |
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. |
|
LastModifiedTime |
Datetime |
For internal use by the Monitoring service. This field was introduced in Skype for Business Server 2015. |