Topic Last Modified: 2013-09-09

Each record represents one session which involves audio or audio and video. It contains overall information about the session. A session is defined as an audio or video Session Initiation Protocol (SIP) dialog between two endpoints.

Column Data Type Key/Index Details

ConferenceDateTime

datetime

Primary

Referenced from the Dialog Table.

SessionSeq

int

Primary

Referenced from the Dialog Table.

ConferenceKey

int

Foreign

Conference key. Referenced from the Conference Table.

CorrelationKey

int

Foreign

Correlation key. Referenced from the SessionCorrelation Table.

DialogCategory

bit

 

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

MediationServerBypassFlag

bit

Flag indicating if the call was bypassed or not.

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

int

Foreign

The pool of the caller. Referenced from the Pool Table.

CalleePool

int

Foreign

The pool of the call receiver. Referenced from the Pool Table.

CalleePAI

int

Foreign

SIP URI in the SIP p-asserted identity (PAI) of the receiving endpoint. Referenced from the User Table.

CallerURI

int

Foreign

Caller’s URI. Referenced from the User Table.

CallerEndpoint

int

Foreign

Caller’s endpoint. Referenced from the Endpoint Table.

CallerUserAgent

bit

Foreign

Caller’s user agent. Referenced from the UserAgent Table.

CallPriority

smallint

The priority of this call.

ClassifiedPoorCall

bit

This column has been deprecated and is not used in Microsoft Lync Server 2013. Instead, this information is reported on a per-media line bases. Refer to the MediaLine Table for more information.

CallerPAI

int

Foreign

P-Asserted-Identity of the user who placed the call. The P-Asserted-Identity (PAI) is used to convey the true identity of the user who placed the call.

CalleeEndpoint

int

Foreign

Endpoint that received the call.

CalleeUserAgent

int

Foreign

User agent employed by the user who received the call. User agents represent the client endpoint device.

CalleeUri

int

Foreign

SIP URI of the user who received the call.