Share via


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:

  • Integrated with desktop phone - 1

CallFlag

smallint

A bit set that indicates the call attributes. The following attribute definitions are listed:

  • Retried Session - 1

* 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.