Topic Last Modified: 2012-10-03

The Session View stores information about sessions that have records in the database. This view was introduced in Microsoft Lync Server 2013.

Column Data Type Details

ConferenceDateTime

datetime

Referenced from the MediaLine Table.

ConferenceURI

nvarchar(450)

Conference URI if this is a conference, or DialogID if this is a peer-to-peer session.

Correlation

varchar(max)

Correlation ID of the session.

DialogCategory

bit

Dialog category; 0 is Lync Server to Mediation Server leg; 1 is Mediation Server to PSTN gateway leg.

MediationServerBypassFlag

bit

Indicates whether or not the call was bypassed.

MediaBypassWarningFlag

int

This field, if present, indicates why a call was not bypassed even if the bypass IDs matched. For Lync Server, only one value is defined:

0x0001 – Unknown bypass ID for Default network adapter

StartTime

datetime

Call start time.

EndTime

datetime

Call end time.

CallerPool

nvarchar(256)

Caller pool FQDN.

CalleePool

nvarchar(256)

Callee pool FQDN.

CallerPAI

nvarchar(450)

Caller’s p-asserted identity URI.

CalleePAI

nvarchar(450)

Callee’s p-asserted identity URI.

CallerEndpoint

nvarchar(256)

Caller’s endpoint name.

CalleeEndpoint

nvarchar(256)

Caller’s endpoint name.

CallerUserAgent

nvarchar(256)

Caller’s user agent string.

CallerUserAgentType

smallint

Type of caller’s user agent. See the UserAgent Table for details.

CallerUserAgentCategory

nvarchar (64)

Category of caller’s user agent. See the UserAgentDef Table (QoE) for details.

CalleeUserAgent

nvarchar(256)

Callee’s user agent string.

CalleeUserAgentType

smallint

Type of user agent for the callee. See the UserAgent Table for details.

CalleeUserAgentCategory

nvarchar (64)

User agent category for the callee. See the UserAgentDef Table (QoE) for details.

CallerURI

nvarchar(450)

Caller’s URI.

CalleeURI

nvarchar(450)

Callee’s URI.

CallPrioirty

int

Priority of the call.