Topic Last Modified: 2010-07-18
Each record represents one session which involves audio or audio/video; it contains overall information about the session. A session is defined as an audio or video SIP dialog between two endpoints.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
|
ConferenceDateTime |
Datetime |
Primary |
Referenced from Dialog Table. |
|
SessionSeq |
Int |
Primary |
Reference from 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 Communications 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 Communications 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 |