Session view
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 Skype for Business 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 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 |
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 for details. |
| CallerUserAgentCategory |
nvarchar (64) |
Category of caller's user agent. See the UserAgentDef table (QoE) for details. |
| CalleeUserAgent |
nvarchar(256) |
Callee's user agent string. |
| CalleeUserAgentType |
smallint |
Type of user agent for the callee. See the UserAgent table for details. |
| CalleeUserAgentCategory |
nvarchar (64) |
User agent category for the callee. See the UserAgentDef table (QoE) for details. |
| CallerURI |
nvarchar(450) |
Caller's URI. |
| CalleeURI |
nvarchar(450) |
Callee's URI. |
| CallPrioirty |
int |
Priority of the call. |