Session table
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 Skype for Business 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 wasn't bypassed even if the bypass IDs matched. For Skype for Business 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 isn't used in Skype for Business Server. Instead, this information is reported on a per-media line basis. For more information, see MediaLine table. |
|
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. |