Topic Last Modified: 2012-10-01

The FocusJoinsAndLeaves view stores information about join and leave information for one conference. Each conference is represented in this view by a record written each time a user joins and leaves the conference. This view was introduced in Microsoft Lync Server 2013.

Column Data Type Details

SessionIdTime

datetime

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

SessionIdSeq

int

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.

UserUri

nvarchar(450)

URI of the user whose conference join/leave information was captured.

UserUriType

nvarchar(256)

Type of URI of the user whose conference join/leave information was captured. See the UriTypes Table for more information.

UserTenant

nvarchar(256)

Tenant of the user whose conference join/leave information was captured. See the Tenants Table for more information.

UserEndpointId

uniqueidentifier

Unique identifier of the user whose conference join/leave information was captured.

UserClientVersion

nvarchar(256)

Version of client used by the user whose conference join/leave information was captured.

UserClientType

int

Client used by the user whose conference join/leave information was captured. See UserAgentDef Table for more details.

UserClientCategory

nvarchar(64)

Name of the category of the client used by the user whose conference join/leave information was captured.

FocusUserInstance

int

IsuserInternal

bit

Bit that represents whether the user is an internal user or not.

DialogSessionIdTime

datetime

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

DialogSessionIdSeq

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.

DialogId

varchar(775)

SIP dialog ID of the session. The format is: dialog;from-tag;to-tag.

UserJoinTime

datetime

Time that the user joined the conference.

UserLeaveTime

datetime

Time that the user left the conference.

UserRole

nvarchar(256)

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