VideoStreamDetail view
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. |