Topic Last Modified: 2012-10-03

The VideoStreamDetail View stores information about each video stream in the database. This view was introduced in Microsoft Lync Server 2013.

Column Data Type Description

SessionTime

datetime

Referenced from the MediaLine Table.

SessionSeq

int

Referenced from the MediaLine Table.

MediaLineLabel

tinyint

Referenced from the MediaLine Table.

StreamId

int

Unique ID within a media line.

StartTime

datetime

Start time of the session.

EndTime

datetime

End time of the session.

CallPriority

int

Priority of the call.

CallerPool

nvarchar(256)

Caller pool FQDN.

CalleePool

nvarchar(256)

Callee pool FQDN.

Caller

nvarchar(450)

Caller’s URI.

Callee

nvarchar(450)

Callee’s URI.

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 callee’s user agent. See the UserAgent Table for information.

CalleeUserAgentCategory

nvarchar(64)

Category of callee’s user agent. See the UserAgentDef Table (QoE) for information.

CallerEndpoint

nvarchar(256)

Caller’s endpoint name.

CalleeEndpoint

nvarchar(256)

Callee’s endpoint name.

CallerOS

nvarchar(128)

Operating system (OS) of the caller’s endpoint.

CalleeOS

nvarchar(128)

Operating system (OS) of the callee’s endpoint.

CallerCPUName

nvarchar(128)

CPU name of the caller’s endpoint.

CalleeCPUName

nvarchar(128)

CPU name of the callee’s endpoint.

CallerCPUNumberOfCores

smallint

Number of CPU cores of the caller’s endpoint.

CalleeCPUNumberOfCores

smallint

Number of CPU cores of the callee’s endpoint.

CallerCPUProcessorSpeed

int

CPU processor speed of the caller’s endpoint.

CalleeCPUProcessorSpeed

int

CPU processor speed of the callee’s endpoint.

CallerVirtualizationFlag

tinyint

Indicates whether the caller’s system is running in a virtualized environment. See the Endpoint Table for more information.

CalleeVirtualizationFlag

tinyint

Indicates whether the callee’s system is running in a virtualized environment. See the Endpoint Table for more information.

ConnectivityIce

tinyint

Information about media path, such as direct or relayed. See the MediaLine Table for more information.

CallerIceWarningFlags

int

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.

CalleeIceWarningFlags

int

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

int

Transport type: 0 is UDP, 1 is TCP.

CallerIPAddr

var(50)

IP address of the caller. This may be either an IPv4 or an IPv6 address.

CallerPort

int

Port used by the caller.

CallerInside

bit

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.

CalleeIPAddr

var(50)

IP address of the callee. This may be either an IPv4 or an IPv6 address.

CalleePort

int

Port used by the callee.

CalleeInside

bit

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.

CallerUserSite

nvarchar(128)

Name of the caller’s site.

CallerRegion

nvarchar(128)

Name of the country/region of the caller’s site.

CalleeUserSite

nvarchar(128)

Name of the callee’s site.

CalleeRegion

nvarchar(128)

Name of the country/region of the callee’s site.

CallerRelayIPAddr

var(50)

IP Address of the A/V Edge service used by the caller. See the IPAddress Table for more information.

CallerRelayPort

int

Port on the A/V Edge service used by the caller.

CalleeRelayIPAddr

var(50)

IP Address key of the A/V Edge service used by the callee. See the IPAddress Table for more information.

CalleeRelayPort

int

Port on the A/V Edge service used by the callee.

CallerCaptureDev

varchar(256)

Caller’s capture device name.

CallerRenderDev

varchar(256)

Caller’s render device name.

CallerCaptureDevDriver

varchar(256)

Caller’s capture device driver name.

CallerRenderDevDriver

varchar(256)

Caller’s render device driver name.

CalleeCaptureDev

varchar(256)

Callee’s capture device name.

CalleeRenderDev

varchar(256)

Callee’s render device name.

CalleCaptureDevDriver

varchar(256)

Callee’s capture device driver name.

CalleeRenderDevDriver

varchar(256)

Callee’s render device driver name.

CallerNetworkConnectionType

tinyint

Caller’s network connection type: 0 is wired, 1 is wireless.

CallerVPN

bit

Indicates whether or not the caller connected over a virtual private network. 1 is virtual private network (VPN), 0 is non-VPN.

CallerLinkSpeed

decimal(18,)

Network link speed for the caller's endpoint in bps.

CalleeNetworkConnectionType

tinyint

Callee’s network connection type: 0 is wired, 1 is wireless.

CalleeVPN

bit

Indicates whether or not the callee connected over a virtual private network. 1 is virtual private network (VPN), 0 is non-VPN.

CalleeLinkSpeed

decimal(18,0)

Network link speed for the callee’s endpoint (in bps).

ConversationalMOS

decimal(3,2)

Narrowband Conversational MOS of the audio sessions (based on both audio streams).

AppliedBandwidthLimit

int

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.

JitterInterArrival

int

Average network jitter from Real Time Control Protocol (RTCP) statistics.

JitterInterArrivalMax

int

Maximum network jitter during the call.

RoundTrip

int

Round trip time from RTCP statistics.

RoundTripMax

int

Maximum round trip time for the audio stream.

PacketLossRate

decimal(5,4)

Average packet loss rate during the call.

PacketLossRateMax

decimal(5,4)

Maximum packet loss observed during the call.

PacketUtilization

int

Packet count for the video stream (Real Time Transport Protocol, RTP).

BandwidthEst

int

Bandwidth estimates for the audio stream.

PayloadDescription

int

Audio codec used for the call, referenced from the PayloadDescription Table.

VideoResolution

char(9)

Resolution of the video in pixels width multiplied by pixels height. Reported as a string.

VideoBitRateAvg

int

Average bit rate of the video stream.

InboundVideoFrameRateAvg

decimal(9,4)

Frame rate of video received.

OutboundVideoFrameRateAvg

decimal(9,4)

Frame rate of video sent.

ViideoBitRateMax

int

Maximum video bit rate during the video session.

VideoPacketLossRate

decimal(9,4)

Rate at which video packets were lost.

VideoFrameLossRate

decimal(9.4)

Percentage of total video frames that are lost.

VideoFEC

bit

Not used.

VideoAllocateBWAvg

int

Average amount of bandwidth allocated for video.

VideoLocalFrameLossPercentageAvg

decimal(9.4)

Percentage of total video frames that were lost.

SenderIsCallerPAI

bit

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.