Share via


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.