FocusJoinsAndLeaves table in Lync Server 2013
Topic Last Modified: 2012-09-28
Each record in this table contains the CDR information about one user’s join and leave information for one conference. Each conference is represented in this table by one record for each time a user joins and leaves the conference.
| 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. |
DialogSessionIdTime |
datetime |
Primary, 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 |
Primary, 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. |
UserId |
int |
Foreign |
Unique number identifying this user, referenced from the Users table in Lync Server 2013. |
FocusUserInstance |
int |
If a user is logged on at multiple computers or devices at the same time, UserInstance is used to uniquely identify the user/device combination. |
|
IsUserInternal |
bit |
|
Whether the user logged on from internal or not. |
UserRole |
int |
|
This user’s role in the conference, such as Presenter or Attendee. |
UserJoinTime |
datetime |
|
The time this user joins the conference. |
UserLeaveTime |
datetime |
|
The time this user leaves the conference. |
ClientVerId |
int |
Foreign |
Version of the user’s client software, referenced to the ClientVersions table in Lync Server 2013. |
UserEndpointId |
uniqueIdentifier |
Globally unique identifier (GUID) of the endpoint used in the conference. This field was introduced in Microsoft Lync Server 2013. |