McuJoinsAndLeaves view

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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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.