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.
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. |