Topic Last Modified: 2012-10-01
The FocusJoinsAndLeaves view stores information about join and leave information for one conference. Each conference is represented in this view by a record written each time a user joins and leaves the conference. This view was introduced in Microsoft Lync Server 2013.
| Column | Data Type | Details |
|---|---|---|
|
SessionIdTime |
datetime |
Time of conference instance. Used in conjunction with SessionIdSeq to uniquely identify a conference instance. See the Conferences Table for more information. |
|
SessionIdSeq |
int |
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. |
|
UserUri |
nvarchar(450) |
URI of the user whose conference join/leave information was captured. |
|
UserUriType |
nvarchar(256) |
Type of URI of the user whose conference join/leave information was captured. See the UriTypes Table for more information. |
|
UserTenant |
nvarchar(256) |
Tenant of the user whose conference join/leave information was captured. See the Tenants Table for more information. |
|
UserEndpointId |
uniqueidentifier |
Unique identifier of the user whose conference join/leave information was captured. |
|
UserClientVersion |
nvarchar(256) |
Version of client used by the user whose conference join/leave information was captured. |
|
UserClientType |
int |
Client used by the user whose conference join/leave information was captured. See UserAgentDef Table for more details. |
|
UserClientCategory |
nvarchar(64) |
Name of the category of the client used by the user whose conference join/leave information was captured. |
|
FocusUserInstance |
int |
|
|
IsuserInternal |
bit |
Bit that represents whether the user is an internal user or not. |
|
DialogSessionIdTime |
datetime |
Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table for more information. |
|
DialogSessionIdSeq |
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. |
|
DialogId |
varchar(775) |
SIP dialog ID of the session. The format is: dialog;from-tag;to-tag. |
|
UserJoinTime |
datetime |
Time that the user joined the conference. |
|
UserLeaveTime |
datetime |
Time that the user left the conference. |
|
UserRole |
nvarchar(256) |
User’s role in the conference, such as Presenter or Attendee. |