Topic Last Modified: 2012-10-01

The McuJoinsAndLeaves view stores information about users join and leave information for one conference server. Each record in this view contains call details about one combination of a user join or leave and conferencing server. 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.

McuUri

nvarchar(256)

The URI of the conferencing server that the user connected to.

McuUriType

nvarchar(256)

The URI of the conferencing server that the user connected to. See the UriTypes Table for more information.

UserUri

nvarchar(450)

The URI of the user whose conferencing server join/leave information was captured.

UserUriType

nvarchar(256)

The type of URI of the user whose conferencing server join/leave information was captured. See the UriTypes Table for more information.

UserTenant

nvarchar(256)

The tenant of the user whose conferencing server join/leave information was captured. See the Tenants Table for more information.

UserClientVersion

nvarchar(256)

The version of client used by the user whose conferencing server join/leave information was captured.

UserClientType

int

The client used by the user whose conferencing server join/leave information was captured. See the UserAgentDef Table for more details.

UserClientCategory

nvarchar(64)

The name of the category of the client used by the user whose conferencing server join/leave information was captured.

McuUserInstance

int

Uniquely identifies the user/device combination for users simultaneously logged on to multiple devices.

IsUserFromPstn

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

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

DialogId

varchar(775)

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

UserJoinTime

datetime

Time the user joined the conferencing server.

UserLeaveTime

datetime

Time the user left the conferencing server.