Lync Server 2013 中的 VideoStreamDetail 视图VideoStreamDetail view in Lync Server 2013

 

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

VideoStreamDetail 视图存储有关每个数据库中视频流的信息。The VideoStreamDetail View stores information about each video stream in the database. 此视图是在 Microsoft Lync Server 2013 中引入的。This view was introduced in Microsoft Lync Server 2013.

Column 数据类型Data Type 说明Description

SessionTimeSessionTime

datetimedatetime

在 Lync Server 2013 中从 MediaLine 表中引用。Referenced from the MediaLine table in Lync Server 2013.

SessionSeqSessionSeq

intint

在 Lync Server 2013 中从 MediaLine 表中引用。Referenced from the MediaLine table in Lync Server 2013.

MediaLineLabelMediaLineLabel

tinyinttinyint

在 Lync Server 2013 中从 MediaLine 表中引用。Referenced from the MediaLine table in Lync Server 2013.

StreamIdStreamId

intint

媒体行中的唯一 ID。Unique ID within a media line.

StartTimeStartTime

datetimedatetime

会话的开始时间。Start time of the session.

EndTimeEndTime

datetimedatetime

会话的结束时间。End time of the session.

CallPriorityCallPriority

intint

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

CallerPoolCallerPool

nvarchar (256) nvarchar(256)

呼叫者池 FQDN。Caller pool FQDN.

CalleePoolCalleePool

nvarchar (256) nvarchar(256)

被叫方池 FQDN。Callee pool FQDN.

CallerCaller

nvarchar (450) nvarchar(450)

呼叫者的 URI。Caller’s URI.

约定Callee

nvarchar (450) nvarchar(450)

被叫方的 URI。Callee’s URI.

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 callee’s user agent. 有关信息,请参阅 Lync Server 2013 中的 UserAgent 表See the UserAgent table in Lync Server 2013 for information.

CalleeUserAgentCategoryCalleeUserAgentCategory

nvarchar (64) nvarchar(64)

被叫方的用户代理类别。Category of callee’s user agent. 有关信息,请参阅 UserAgentDef 表 (QoE) In Lync Server 2013See the UserAgentDef table (QoE) in Lync Server 2013 for information.

CallerEndpointCallerEndpoint

nvarchar (256) nvarchar(256)

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

CalleeEndpointCalleeEndpoint

nvarchar (256) nvarchar(256)

被叫方的终结点名称。Callee’s endpoint name.

CallerOSCallerOS

nvarchar (128) nvarchar(128)

呼叫者终结点的操作系统 (OS)。Operating system (OS) of the caller’s endpoint.

CalleeOSCalleeOS

nvarchar (128) nvarchar(128)

被叫方终结点的操作系统 (OS)。Operating system (OS) of the callee’s endpoint.

CallerCPUNameCallerCPUName

nvarchar (128) nvarchar(128)

呼叫者终结点的 CPU 名称。CPU name of the caller’s endpoint.

CalleeCPUNameCalleeCPUName

nvarchar (128) nvarchar(128)

被叫方终结点的 CPU 名称。CPU name of the callee’s endpoint.

CallerCPUNumberOfCoresCallerCPUNumberOfCores

smallintsmallint

呼叫者的终结点的 CPU 内核数。Number of CPU cores of the caller’s endpoint.

CalleeCPUNumberOfCoresCalleeCPUNumberOfCores

smallintsmallint

被叫方的终结点的 CPU 内核数。Number of CPU cores of the callee’s endpoint.

CallerCPUProcessorSpeedCallerCPUProcessorSpeed

intint

呼叫者终结点的 CPU 处理器速度。CPU processor speed of the caller’s endpoint.

CalleeCPUProcessorSpeedCalleeCPUProcessorSpeed

intint

被叫方终结点的 CPU 处理器速度。CPU processor speed of the callee’s endpoint.

CallerVirtualizationFlagCallerVirtualizationFlag

tinyinttinyint

指示呼叫者的系统是否正在虚拟化环境中运行。Indicates whether the caller’s system is running in a virtualized environment. 有关详细信息,请参阅 Lync Server 2013 中的终结点表See the Endpoint table in Lync Server 2013 for more information.

CalleeVirtualizationFlagCalleeVirtualizationFlag

tinyinttinyint

指示被叫方的系统是否正在虚拟化环境中运行。Indicates whether the callee’s system is running in a virtualized environment. 有关详细信息,请参阅 Lync Server 2013 中的终结点表See the Endpoint table in Lync Server 2013 for more information.

ConnectivityIceConnectivityIce

tinyinttinyint

有关媒体路径的信息,例如直接或中继。Information about media path, such as direct or relayed. 有关详细信息,请参阅 Lync Server 2013 中的 MediaLine 表See the MediaLine table in Lync Server 2013 for more information.

CallerIceWarningFlagsCallerIceWarningFlags

intint

关于呼叫者的位标志中所述的互动式连接建立 (ICE) 过程的信息。有关详细信息,请参阅“用户体验质量监控服务器协议规范”。Information about Interactive Connectivity Establishment (ICE) process described in bits flags for the caller. For details, refer to the Quality of Experience Monitoring Server Protocol Specification.

CalleeIceWarningFlagsCalleeIceWarningFlags

intint

关于被叫方的位标志中所述的互动式连接建立 (ICE) 过程的信息。有关详细信息,请参阅“用户体验质量监控服务器协议规范”。Information about Interactive Connectivity Establishment (ICE) process described in bits flags for the callee. For details, refer to the Quality of Experience Monitoring Server Protocol Specification.

TransportTransport

intint

传输类型:0 是 UDP,1 是 TCP。Transport type: 0 is UDP, 1 is TCP.

CallerIPAddrCallerIPAddr

var (50) var(50)

呼叫者的 IP 地址。IP address of the caller. 这可能是 IPv4 或 IPv6 地址。This may be either an IPv4 or an IPv6 address.

CallerPortCallerPort

intint

呼叫者使用的端口。Port used by the caller.

CallerInsideCallerInside

bit

指示呼叫者是否位于组织网络的内部。1 表示呼叫者位于企业网络内部,0 表示呼叫者位于该网络外部。Indicates whether the caller is inside the organization network. 1 means caller is inside the enterprise network, 0 means the caller is outside the network.

CalleeIPAddrCalleeIPAddr

var (50) var(50)

被叫方的 IP 地址。IP address of the callee. 这可能是 IPv4 或 IPv6 地址。This may be either an IPv4 or an IPv6 address.

CalleePortCalleePort

intint

被叫方所使用的端口。Port used by the callee.

CalleeInsideCalleeInside

bit

指示呼叫者是否位于组织网络的内部。1 表示被叫方位于企业网络内部,0 表示被叫方位于该网络外部。Indicates whether the caller is inside the organization network.1 means callee is inside the enterprise network, 0 means the callee is outside the network.

CallerUserSiteCallerUserSite

nvarchar (128) nvarchar(128)

呼叫者的站点名称。Name of the caller’s site.

CallerRegionCallerRegion

nvarchar (128) nvarchar(128)

呼叫者站点的国家/地区名称。Name of the country/region of the caller’s site.

CalleeUserSiteCalleeUserSite

nvarchar (128) nvarchar(128)

被叫方的站点名称。Name of the callee’s site.

CalleeRegionCalleeRegion

nvarchar (128) nvarchar(128)

被叫方站点的国家/地区名称。Name of the country/region of the callee’s site.

CallerRelayIPAddrCallerRelayIPAddr

var (50) var(50)

呼叫者所使用的 A/V 边缘服务的 IP 地址。IP Address of the A/V Edge service used by the caller. 有关详细信息,请参阅 Lync Server 2013 中的 "Ip 地址" 表See the IPAddress table in Lync Server 2013 for more information.

CallerRelayPortCallerRelayPort

intint

呼叫者使用的 A/V 边缘服务上的端口。Port on the A/V Edge service used by the caller.

CalleeRelayIPAddrCalleeRelayIPAddr

var (50) var(50)

被叫方所使用的 A/V 边缘服务的 IP 地址密钥。IP Address key of the A/V Edge service used by the callee. 有关详细信息,请参阅 Lync Server 2013 中的 "Ip 地址" 表See the IPAddress table in Lync Server 2013 for more information.

CalleeRelayPortCalleeRelayPort

intint

被叫方使用的 A/V 边缘服务上的端口。Port on the A/V Edge service used by the callee.

CallerCaptureDevCallerCaptureDev

varchar (256) varchar(256)

呼叫者的捕获设备名称。Caller’s capture device name.

CallerRenderDevCallerRenderDev

varchar (256) varchar(256)

呼叫者的呈现设备名称。Caller’s render device name.

CallerCaptureDevDriverCallerCaptureDevDriver

varchar (256) varchar(256)

呼叫者的捕获设备驱动程序名称。Caller’s capture device driver name.

CallerRenderDevDriverCallerRenderDevDriver

varchar (256) varchar(256)

呼叫者的呈现设备驱动程序名称。Caller’s render device driver name.

CalleeCaptureDevCalleeCaptureDev

varchar (256) varchar(256)

被叫方的捕获设备名称。Callee’s capture device name.

CalleeRenderDevCalleeRenderDev

varchar (256) varchar(256)

被叫方的呈现设备名称。Callee’s render device name.

CalleCaptureDevDriverCalleCaptureDevDriver

varchar (256) varchar(256)

被叫方的捕获设备驱动程序名称。Callee’s capture device driver name.

CalleeRenderDevDriverCalleeRenderDevDriver

varchar (256) varchar(256)

被叫方的呈现设备驱动程序名称。Callee’s render device driver name.

CallerNetworkConnectionTypeCallerNetworkConnectionType

tinyinttinyint

呼叫者的网络连接类型:0 是有线,1 是无线。Caller’s network connection type: 0 is wired, 1 is wireless.

CallerVPNCallerVPN

bit

指示呼叫者是否通过虚拟专用网络连接:1 是虚拟专用网络 (VPN),0 是非 VPN。Indicates whether or not the caller connected over a virtual private network. 1 is virtual private network (VPN), 0 is non-VPN.

CallerLinkSpeedCallerLinkSpeed

十进制 (18,) decimal(18,)

呼叫者终结点的网络链接速度(以 bps 为单位)。Network link speed for the caller's endpoint in bps.

CalleeNetworkConnectionTypeCalleeNetworkConnectionType

tinyinttinyint

被叫方的网络连接类型:0 是有线,1 是无线。Callee’s network connection type: 0 is wired, 1 is wireless.

CalleeVPNCalleeVPN

bit

指示被叫方是否通过虚拟专用网络连接:1 是虚拟专用网络 (VPN),0 是非 VPN。Indicates whether or not the callee connected over a virtual private network. 1 is virtual private network (VPN), 0 is non-VPN.

CalleeLinkSpeedCalleeLinkSpeed

十进制 (18,0) decimal(18,0)

被叫方终结点的网络链接速度(以 bps 为单位)。Network link speed for the callee’s endpoint (in bps).

ConversationalMOSConversationalMOS

十进制 (3、2) decimal(3,2)

音频会话的窄带交谈 MOS(基于两个音频流)。Narrowband Conversational MOS of the audio sessions (based on both audio streams).

AppliedBandwidthLimitAppliedBandwidthLimit

intint

应用于指定发送端流指定的多种策略设置(TURN、API、SDP、策略服务器等)的实际带宽。不要将其与有效带宽混淆,因为根据带宽预估的不同,可能会降低带宽的有效性。这基本上是发送流可禁止带宽预估设定的限制的最大带宽。Actual bandwidth applied to the given send side stream given various policy settings (TURN, API, SDP, Policy Server, and so on). This is not to be confused with the effective bandwidth because there can be a lower effective bandwidth based on the bandwidth estimate. This is basically the maximum bandwidth the send stream can take barring limits imposed by the bandwidth estimate.

JitterInterArrivalJitterInterArrival

intint

实时控制协议 (RTCP) 统计信息中的平均网络抖动。Average network jitter from Real Time Control Protocol (RTCP) statistics.

JitterInterArrivalMaxJitterInterArrivalMax

intint

呼叫期间的最大网络抖动。Maximum network jitter during the call.

工程RoundTrip

intint

RTCP 统计信息中的来回行程时间。Round trip time from RTCP statistics.

RoundTripMaxRoundTripMax

intint

音频流的最大来回行程时间。Maximum round trip time for the audio stream.

PacketLossRatePacketLossRate

十进制 (5、4) decimal(5,4)

呼叫期间的平均数据包丢失率。Average packet loss rate during the call.

PacketLossRateMaxPacketLossRateMax

十进制 (5、4) decimal(5,4)

呼叫期间观测到的数据包丢失最大值。Maximum packet loss observed during the call.

PacketUtilizationPacketUtilization

intint

视频流的数据包计数(实时传输协议,RTP)。Packet count for the video stream (Real Time Transport Protocol, RTP).

BandwidthEstBandwidthEst

intint

音频流的带宽预估。Bandwidth estimates for the audio stream.

PayloadDescriptionPayloadDescription

intint

用于呼叫的音频编解码器,从 Lync Server 2013 中的 PayloadDescription 表中引用。Audio codec used for the call, referenced from the PayloadDescription table in Lync Server 2013.

VideoResolutionVideoResolution

char (9) char(9)

视频的分辨率(像素宽乘以像素高)。报告为字符串。Resolution of the video in pixels width multiplied by pixels height. Reported as a string.

VideoBitRateAvgVideoBitRateAvg

intint

视频流的平均比特率。Average bit rate of the video stream.

InboundVideoFrameRateAvgInboundVideoFrameRateAvg

十进制 (9、4) decimal(9,4)

接收的视频帧速率。Frame rate of video received.

OutboundVideoFrameRateAvgOutboundVideoFrameRateAvg

十进制 (9、4) decimal(9,4)

发送的视频帧速率。Frame rate of video sent.

ViideoBitRateMaxViideoBitRateMax

intint

视频会话期间的最大视频比特率。Maximum video bit rate during the video session.

VideoPacketLossRateVideoPacketLossRate

十进制 (9、4) decimal(9,4)

视频数据包丢失的比特率。Rate at which video packets were lost.

VideoFrameLossRateVideoFrameLossRate

十进制 (9.4) decimal(9.4)

丢失的全部视频帧的百分比。Percentage of total video frames that are lost.

VideoFECVideoFEC

bit

未使用。Not used.

VideoAllocateBWAvgVideoAllocateBWAvg

intint

为视频分配的平均带宽量。Average amount of bandwidth allocated for video.

VideoLocalFrameLossPercentageAvgVideoLocalFrameLossPercentageAvg

十进制 (9.4) decimal(9.4)

丢失的全部视频帧的百分比。Percentage of total video frames that were lost.

SenderIsCallerPAISenderIsCallerPAI

bit

已断言标识信息的流方向。1 表示流方向从呼叫者到被叫方;0 表示流方向从被叫方到呼叫者。Stream direction for p-asserted identity information. 1 means the stream direction is from the caller to the callee; 0 means the stream direction is from the callee to the caller.