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 was not 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 is not used in Skype for Business Server. 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.