Topic Last Modified: 2012-10-01

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 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 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 for more information.

DeviceHardwareVersion

nvarchar(256)

Hardware version of the device registered. See the HardwareVersions Table for more information.