Lync Server 2013 中的 VideoStreamDetail 視圖VideoStreamDetail view in Lync Server 2013

 

主題上次修改日期: 2012-10-03Topic Last Modified: 2012-10-03

VideoStreamDetail View 儲存資料庫中每個影片資料流程的資訊。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

媒體行中的唯一識別碼。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. 如需詳細資訊,請參閱 UserAgentDef 表格 (Lync Server 2013 中的 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 table (QoE) 中的 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

媒體路徑的相關資訊,例如 direct 或中繼。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.

傳輸Transport

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

會指出來電者是否在組織網路內。Indicates whether the caller is inside the organization network. 1表示來電者位於商業網路內,0表示來電者位於網路外。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 Edge Service 的 IP 位址。IP Address of the A/V Edge service used by the caller. 如需詳細資訊,請參閱 Lync Server 2013 中的 IPAddress 表格See the IPAddress table in Lync Server 2013 for more information.

CallerRelayPortCallerRelayPort

intint

呼叫者所使用 A/V Edge service 上的埠。Port on the A/V Edge service used by the caller.

CalleeRelayIPAddrCalleeRelayIPAddr

var (50) var(50)

被呼叫者所使用之 A/V Edge service 的 IP 位址金鑰。IP Address key of the A/V Edge service used by the callee. 如需詳細資訊,請參閱 Lync Server 2013 中的 IPAddress 表格See the IPAddress table in Lync Server 2013 for more information.

CalleeRelayPortCalleeRelayPort

intint

被呼叫者所使用 A/V Edge service 上的埠。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

會指出呼叫者是否透過虛擬專用網路連接。Indicates whether or not the caller connected over a virtual private network. 1 是虛擬私人網路 (VPN),0 是非 VPN。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

會指出是否已透過虛擬專用網路連接被呼叫者。Indicates whether or not the callee connected over a virtual private network. 1 是虛擬私人網路 (VPN),0 是非 VPN。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

針對指定之傳送端資料流程套用至指定之傳送端資料流程的實際頻寬,可 (轉換、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

P-宣稱身分識別資訊的資料流程方向。Stream direction for p-asserted identity information. 1表示資料流程是從來電者流向被呼叫者;0表示資料流程方向從被叫方傳送給來電者。1 means the stream direction is from the caller to the callee; 0 means the stream direction is from the callee to the caller.