ConferenceSessionDetails table in Lync Server 2013
Topic Last Modified: 2012-09-28
Each record represents one conference session, which could be either the session with Focus or the session with a specific conferencing server.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
SessionIdTime |
Datetime |
Primary, Foreign |
Time of session request; used in conjunction with SessionIdSeq to uniquely identify a conference session. See the Dialogs table in Lync Server 2013 for more information. |
SessionIdSeq |
int |
Primary, Foreign |
ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a conference session. See the Dialogs table in Lync Server 2013 for more information. * |
ConferenceUriId |
int |
Foreign |
Focus conference URI related to this session. See the ConferenceUris table in Lync Server 2013 for more information. This URI is a Focus-based conference URI. |
ConfInstance |
uniqueIdentifier |
Identifier that differentiates between instances of recurring conferences. Each recurring conference instance has the same ConferenceURI but a different ConfInstance value. This field was introduced in Microsoft Lync Server 2013. |
|
McuConferenceUriId |
int |
Foreign |
Conferencing server conference URI related to this session. See the ConferenceUris table in Lync Server 2013 for more information. This URI is the conferencing server-based conference URI. For Focus conference sessions, this column will be null. |
UserId |
int |
Foreign |
ID of one user in the conference session. See the Users table in Lync Server 2013 for more information. |
UserEndpointId |
uniqueidentifier |
A GUID to identify the instance of endpoint. For example, if one user logs on to different machines with the same account, then each machine will have a different endpoint ID. |
|
OnBehalfOfId |
int |
Foreign |
Indicates the ID of the user of who the caller is on behalf. See the Users table in Lync Server 2013 for more information. |
ReferredById |
int |
Foreign |
ID of the user by who the call is referred. See the Users table in Lync Server 2013 for more information. |
UserClientVersionId |
int |
Foreign |
Client version used by the conference user. See the ClientVersions table in Lync Server 2013 for more information. |
ConfClientVersionId |
int |
Foreign |
Client version used by the conference server. See the ClientVersions table in Lync Server 2013 for more information. |
ReplaceDialogIdTime |
datetime |
Foreign |
ID number to identify the dialog which was replaced by current session. See the Dialogs table in Lync Server 2013 for more information. |
ReplaceDialogIdSeq |
int |
Foreign |
ID number to identify the session. Used in conjunction with ReplacesDialogIdTime to uniquely identify a session that is replaced by this session. See the Dialogs table in Lync Server 2013 for more information. |
IsStartedByConfServer |
bit |
Indicates if the session started by the conferencing Server. |
|
IsEndedByConfServer |
bit |
Indicates if the session ended by the conferencing server. |
|
IsUserInternal |
bit |
Whether user is logged on from internal or not. |
|
ResponseCode |
int |
Session Initiation Protocol (SIP) response code to the session invitation. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO). |
|
DiagnosticId |
int |
Diagnostic ID captured from SIP header. |
|
ServerId |
int |
Foreign |
ID of the front-end server used for this session. See the Servers table in Lync Server 2013 for more information. |
PoolId |
int |
Foreign |
ID of the pool in which the session was captured. See the Pools table in Lync Server 2013 for more information. |
MediationServerId |
int |
Foreign |
The Mediation Server the call is using. See the MediationServers table in Lync Server 2013 for more information. |
GatewayId |
int |
Foreign |
The gateway the call is using. See the Gateways table in Lync Server 2013 for more information. |
EdgeServerId |
int |
Foreign |
The Edge Server the call is using. See the EdgeServers table in Lync Server 2013 for more information. |
ContentTypeId |
int |
Foreign |
Content type used in the session. See the ContentTypes table in Lync Server 2013 for more information. |
InviteTime |
datetime |
The time of the first INVITE request. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO). |
|
ResponseTime |
datetime |
Time of the first SIP RESPONSE. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO). |
|
SessionEndTime |
datetime |
The time when the session is ended. |
|
UriTypeId |
tinyint |
Foreign |
Contains the MCU URI type value from the UriTypes table in Lync Server 2013. This field is used for improving query performance. This field was introduced in Microsoft Lync Server 2013. |
UserFlag |
smallint |
A bit set that indicates the user attributes. The following attribute definitions are listed:
|
|
CallFlag |
smallint |
A bit set that indicates the call attributes. The following attribute definitions are listed:
|
* For most sessions, SessionIdSeq will have the value of 1. If multiple sessions start at exactly the same time, the SessionIdSeq for one will be 1, for another will be 2, and so on.