Share via


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.