VideoStreamDetail view in Lync Server 2013

 

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 in Lync Server 2013.
SessionSeq	int	Referenced from the MediaLine table in Lync Server 2013.
MediaLineLabel	tinyint	Referenced from the MediaLine table in Lync Server 2013.
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 in Lync Server 2013 for details.
CallerUserAgentCategory	nvarchar(64)	Category of caller’s user agent. See the UserAgentDef table (QoE) in Lync Server 2013 for details.
CalleeUserAgent	nvarchar(256)	Callee’s user agent string.
CalleeUserAgentType	smallint	Type of callee’s user agent. See the UserAgent table in Lync Server 2013 for information.
CalleeUserAgentCategory	nvarchar(64)	Category of callee’s user agent. See the UserAgentDef table (QoE) in Lync Server 2013 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 in Lync Server 2013 for more information.
CalleeVirtualizationFlag	tinyint	Indicates whether the callee’s system is running in a virtualized environment. See the Endpoint table in Lync Server 2013 for more information.
ConnectivityIce	tinyint	Information about media path, such as direct or relayed. See the MediaLine table in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013.
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.