McuJoinsAndLeaves table in Lync Server 2013
Topic Last Modified: 2012-09-28
Each record in this table contains call details about one combination of a user join or leave and conferencing server. For example, if a user joins a conference that includes web conferencing and audio/video elements, one record would be created for that user’s web conferencing join, and another record would be created for the user’s audio/video conferencing join.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
SessionIdTime |
datetime |
Primary, Foreign |
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 |
Primary, Foreign |
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. |
UserId |
int |
Primary, Foreign |
Unique number identifying this user. See the Users table in Lync Server 2013 for more information. |
McuUserInstance |
int |
Primary |
If a user is logged on at multiple computers or devices at once, McuUserInstance uniquely identifies the user/device combination. |
IsFromPstn |
bit |
|
Whether the user is joining from a PSTN or not. |
McuId |
int |
Primary, Foreign |
Unique number identifying this conferencing server. See the Mcus table in Lync Server 2013 for more information. |
DialogSessionIdTime |
datetime |
Foreign |
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 |
Foreign |
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. |
UserJoinTime |
datetime |
|
The time this user joins this conferencing server. |
UserLeaveTime |
datetime |
|
The time this user leaves this conferencing server. |
ClientVerId |
int |
Foreign |
Identifier that specifies the version number of the client software use in the conference. See the ClientVersions table in Lync Server 2013 for more information. This field was introduced in Microsoft Lync Server 2013. |