Session view in Lync Server 2013
Topic Last Modified: 2012-10-03
The Session View stores information about sessions that have records in the database. This view was introduced in Microsoft Lync Server 2013.
| Column | Data Type | Details |
|---|---|---|
ConferenceDateTime |
datetime |
Referenced from the MediaLine Table. |
ConferenceURI |
nvarchar(450) |
Conference URI if this is a conference, or DialogID if this is a peer-to-peer session. |
Correlation |
varchar(max) |
Correlation ID of the session. |
DialogCategory |
bit |
Dialog category; 0 is Lync Server to Mediation Server leg; 1 is Mediation Server to PSTN gateway leg. |
MediationServerBypassFlag |
bit |
Indicates whether or not the call was bypassed. |
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 |
nvarchar(256) |
Caller pool FQDN. |
CalleePool |
nvarchar(256) |
Callee pool FQDN. |
CallerPAI |
nvarchar(450) |
Caller’s p-asserted identity URI. |
CalleePAI |
nvarchar(450) |
Callee’s p-asserted identity URI. |
CallerEndpoint |
nvarchar(256) |
Caller’s endpoint name. |
CalleeEndpoint |
nvarchar(256) |
Caller’s endpoint name. |
CallerUserAgent |
nvarchar(256) |
Caller’s user agent string. |
CallerUserAgentType |
smallint |
Type of caller’s user agent. See the UserAgent table in Lync Server 2013 for details. |
CallerUserAgentCategory |
nvarchar (64) |
Category of caller’s user agent. See the UserAgentDef table (QoE) in Lync Server 2013 for details. |
CalleeUserAgent |
nvarchar(256) |
Callee’s user agent string. |
CalleeUserAgentType |
smallint |
Type of user agent for the callee. See the UserAgent table in Lync Server 2013 for details. |
CalleeUserAgentCategory |
nvarchar (64) |
User agent category for the callee. See the UserAgentDef table (QoE) in Lync Server 2013 for details. |
CallerURI |
nvarchar(450) |
Caller’s URI. |
CalleeURI |
nvarchar(450) |
Callee’s URI. |
CallPrioirty |
int |
Priority of the call. |