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 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 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 for more information.

DialogSessionIdTime

datetime

Foreign

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table 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 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 for more information.

This field was introduced in Microsoft Lync Server 2013.