FocusJoinsAndLeaves view
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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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. |