Session table in Lync Server 2013
Topic Last Modified: 2013-09-09
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 in Lync Server 2013. |
SessionSeq |
int |
Primary |
Referenced from the Dialog table in Lync Server 2013. |
ConferenceKey |
int |
Foreign |
Conference key. Referenced from the Conference table in Lync Server 2013. |
CorrelationKey |
int |
Foreign |
Correlation key. Referenced from the SessionCorrelation table in Lync Server 2013. |
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, 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 in Lync Server 2013. |
CalleePool |
int |
Foreign |
The pool of the call receiver. Referenced from the Pool table in Lync Server 2013. |
CalleePAI |
int |
Foreign |
SIP URI in the SIP p-asserted identity (PAI) of the receiving endpoint. Referenced from the User table in Lync Server 2013. |
CallerURI |
int |
Foreign |
Caller’s URI. Referenced from the User table in Lync Server 2013. |
CallerEndpoint |
int |
Foreign |
Caller’s endpoint. Referenced from the Endpoint table in Lync Server 2013. |
CallerUserAgent |
bit |
Foreign |
Caller’s user agent. Referenced from the UserAgent table in Lync Server 2013. |
CallPriority |
smallint |
The priority of this call. |
|
ClassifiedPoorCall |
bit |
This column has been deprecated and is not used in Microsoft Lync Server 2013. Instead, this information is reported on a per-media line bases. Refer to the MediaLine table in Lync Server 2013 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. |