McuJoinsAndLeaves table in Skype for Business Server 2015
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 Skype for Business Server 2015 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 Skype for Business Server 2015 for more information. |
| UserId |
int |
Primary, Foreign |
Unique number identifying this user. See the Users table 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 Skype for Business Server 2015 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 Skype for Business Server 2015 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 Skype for Business Server 2015 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 Skype for Business Server 2015 for more information. This field was introduced in Microsoft Lync Server 2013. |
| LastModifiedTime |
Datetime |
For internal use by the Monitoring service. This field was introduced in Skype for Business Server 2015. |