Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO: 
2015 
2019
Subscription Edition
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. |