FocusJoinsAndLeaves table in Skype for Business Server 2015

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 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.
DialogSessionIdTime
datetime
Primary, 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
Primary, 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.
UserId
int
Foreign
Unique number identifying this user, referenced from the Users table.
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 Skype for Business Server 2015.
UserEndpointId
uniqueIdentifier
Globally unique identifier (GUID) of the endpoint used in the conference.
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.