Registration table

  • Article

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. See the Dialogs table in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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.
LastModifiedTime
Datetime
For internal use by the Monitoring service.
This field was introduced in Skype for Business Server 2015.