Registration view
The Registration view stores information about user registration. This view was introduced in Lync Server 2013.
| Column | Data Type | Details |
|---|---|---|
| SessionIdTime |
datetime |
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 |
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. |
| RegisterTime |
datetime |
Time at which registration occurred. |
| UserUri |
nvarchar(450) |
URI of the user who registered. |
| UserUriType |
nvarchar(256) |
Type of URI of the user who registered. See the UriTypes table for more information. |
| UserTenant |
nvarchar(256) |
Tenant of the user who registered. See the Tenants table for more information. |
| EndpointId |
uniqueidentifier |
Unique identifier of the endpoint of the user registered with. |
| EndpointEra |
uniqueidentifier |
Unique identifier used to differentiate registrations that involve the same user and the same endpoint. |
| DeRegisterType |
datetime |
Time at which deregistration occurred. |
| DeRegisterReason |
nvarchar(256) |
Reason for deregistration. |
| ClientVersion |
nvarchar(256) |
Version of client used by the user who registered. |
| ClientType |
int |
Client used by the user who registered. See the UserAgentDef table for more details. |
| ClientCategory |
nvarchar(64) |
Category of the client used by the user who registered. |
| IpAddress |
nvarchar(256) |
IP Address the user registered with. This may be an IPv4 or IPv6 address. |
| DialogId |
varstring(775) |
SIP dialog ID. The format of the is: dialog;from-tag;to-tag |
| ResponseCode |
int |
SIP response code to the session invitation. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO). |
| DiagnosticId |
int |
Diagnostic ID captured from SIP header. |
| Registrar |
nvarchar(256) |
FQDN of the Registrar. |
| Pool |
nvarchar(256) |
FQDN of the pool that captured the data for the session. |
| EdgeServer |
nvarchar(256) |
FQDN of the Edge Server used by the user who registered. |
| IsInternal |
bit |
Indicates whether the user logged on from the internal network. |
| IsUserServiceAvailable |
bit |
Indicates whether the UserService was available at registration time. |
| IsPrimaryRegistrar |
bit |
Indicates whether registration was with the primary Registrar. |
| DeviceMacAddress |
bigint |
MAC Address of device registered. |
| DeviceManufacturer |
nvarchar(256) |
Manufacturer of the device registered. See the Manufacturers table in Skype for Business Server 2015 for more information. |
| DeviceHardwareVersion |
nvarchar(256) |
Hardware version of the device registered. See the HardwareVersions table in Skype for Business Server 2015 for more information. |