McuJoinsAndLeaves view in Lync Server 2013
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 in Lync Server 2013 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 Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 for more information. |
UserTenant |
nvarchar(256) |
The tenant of the user whose conferencing server join/leave information was captured. See the Tenants table in Lync Server 2013 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 in Lync Server 2013 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 Lync Server 2013 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 Lync Server 2013 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. |