SessionIdTime

datetime

Primary, Foreign

Time of conference instance. Used in conjunction with SessionIdSeq to uniquely identify a conference instance. See the Conferences Table for more information.

SessionIdSeq

int

Primary, Foreign

ID number to identify the conference instance. Used in conjunction with SessionIdTime to uniquely identify a conference instance. See the Conferences Table for more information.

DialogSessionIdTime

datetime

Primary, Foreign

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table for more information.

DialogSessionIdSeq

int

Primary, Foreign

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. see the Dialogs Table for more information.

UserId

int

Foreign

Unique number identifying this user, referenced from the Users Table.

FocusUserInstance

int

If a user is logged on at multiple computers or devices at the same time, UserInstance is used to uniquely identify the user/device combination.

IsUserInternal

bit

Whether the user logged on from internal or not.

UserRole

int

This user’s role in the conference, such as Presenter or Attendee.

UserJoinTime

datetime

The time this user joins the conference.

UserLeaveTime

datetime

The time this user leaves the conference.

ClientVerId

int

Foreign

Version of the user’s client software, referenced to the ClientVersions Table.

UserEndpointId

uniqueIdentifier

Globally unique identifier (GUID) of the endpoint used in the conference.

This field was introduced in Microsoft Lync Server 2013.