Topic Last Modified: 2010-12-12

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

Reference 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 2010, 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

0: good call

1: poor call

Null: unknown due to the lack of necessary metrics.