Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |