FocusJoinsAndLeaves view in Lync Server 2013
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 in Lync Server 2013 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 Lync Server 2013 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 in Lync Server 2013 for more information. |
UserTenant |
nvarchar(256) |
Tenant of the user whose conference join/leave information was captured. See the Tenants table in Lync Server 2013 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 in Lync Server 2013 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 Lync Server 2013 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. |