Lync Server 2013 中的会话视图Session view in Lync Server 2013

 

上次修改的主题: 2012-10-03Topic Last Modified: 2012-10-03

会话视图存储有关在数据库中具有记录的会话的信息。The Session View stores information about sessions that have records in the database. 此视图是在 Microsoft Lync Server 2013 中引入的。This view was introduced in Microsoft Lync Server 2013.

Column 数据类型Data Type 详细信息Details

ConferenceDateTimeConferenceDateTime

datetimedatetime

引用自 MediaLine 表。Referenced from the MediaLine Table.

ConferenceURIConferenceURI

nvarchar (450) nvarchar(450)

如果是会议,则是会议 URI;如果是点对点会话,则是 DialogID。Conference URI if this is a conference, or DialogID if this is a peer-to-peer session.

相关性Correlation

varchar (max) varchar(max)

会话的关联 ID。Correlation ID of the session.

DialogCategoryDialogCategory

bit

对话框类别;0是 Lync Server 以进行中介服务器腿;1是中介服务器到 PSTN 网关腿。Dialog category; 0 is Lync Server to Mediation Server leg; 1 is Mediation Server to PSTN gateway leg.

MediationServerBypassFlagMediationServerBypassFlag

bit

指示是否旁路了呼叫。Indicates whether or not the call was bypassed.

MediaBypassWarningFlagMediaBypassWarningFlag

intint

如果存在,此字段指示即使绕过 ID 相匹配也没有绕过呼叫的原因。This field, if present, indicates why a call was not bypassed even if the bypass IDs matched. 对于 Lync Server,仅定义了一个值:For Lync Server, only one value is defined:

0x0001 – 默认网络适配器的未知旁路 ID0x0001 – Unknown bypass ID for Default network adapter

StartTimeStartTime

datetimedatetime

呼叫开始时间。Call start time.

EndTimeEndTime

datetimedatetime

呼叫结束时间。Call end time.

CallerPoolCallerPool

nvarchar (256) nvarchar(256)

呼叫者池 FQDN。Caller pool FQDN.

CalleePoolCalleePool

nvarchar (256) nvarchar(256)

被叫方池 FQDN。Callee pool FQDN.

CallerPAICallerPAI

nvarchar (450) nvarchar(450)

呼叫者的 p 已断言标识 URI。Caller’s p-asserted identity URI.

CalleePAICalleePAI

nvarchar (450) nvarchar(450)

被叫方的 p 已断言标识 URI。Callee’s p-asserted identity URI.

CallerEndpointCallerEndpoint

nvarchar (256) nvarchar(256)

呼叫者的终结点名称。Caller’s endpoint name.

CalleeEndpointCalleeEndpoint

nvarchar (256) nvarchar(256)

呼叫者的终结点名称。Caller’s endpoint name.

CallerUserAgentCallerUserAgent

nvarchar (256) nvarchar(256)

呼叫者的用户代理字符串。Caller’s user agent string.

CallerUserAgentTypeCallerUserAgentType

smallintsmallint

呼叫者的用户代理类型。Type of caller’s user agent. 有关详细信息,请参阅 Lync Server 2013 中的 UserAgent 表See the UserAgent table in Lync Server 2013 for details.

CallerUserAgentCategoryCallerUserAgentCategory

nvarchar (64)nvarchar (64)

呼叫者的用户代理的类别。Category of caller’s user agent. 有关详细信息,请参阅 Lync Server 2013 中的 UserAgentDef 表 (QoE) See the UserAgentDef table (QoE) in Lync Server 2013 for details.

CalleeUserAgentCalleeUserAgent

nvarchar (256) nvarchar(256)

被叫方的用户代理字符串。Callee’s user agent string.

CalleeUserAgentTypeCalleeUserAgentType

smallintsmallint

被叫方的用户代理的类型。Type of user agent for the callee. 有关详细信息,请参阅 Lync Server 2013 中的 UserAgent 表See the UserAgent table in Lync Server 2013 for details.

CalleeUserAgentCategoryCalleeUserAgentCategory

nvarchar (64)nvarchar (64)

被叫方的用户代理类别。User agent category for the callee. 有关详细信息,请参阅 Lync Server 2013 中的 UserAgentDef 表 (QoE) See the UserAgentDef table (QoE) in Lync Server 2013 for details.

CallerURICallerURI

nvarchar (450) nvarchar(450)

呼叫者的 URI。Caller’s URI.

CalleeURICalleeURI

nvarchar (450) nvarchar(450)

被叫方的 URI。Callee’s URI.

CallPrioirtyCallPrioirty

intint

呼叫的优先级。Priority of the call.