AudioStreamDetail view in Lync Server 2013

 

Topic Last Modified: 2012-10-03

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

Column	Data Type	Details
SessionTime	datetime	Referenced from the MediaLine table in Lync Server 2013.
SessionSeq	int	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.
DialogCategory	bit	Dialog category: 0 is the Lync Server to Mediation Server leg; 1 is the Mediation Server to PSTN gateway leg.
MediationServerBypassFlag	bit	Flag indicating if the call was bypassed or not.
MediaBypassWarningFlag	int	If present, indicates why a call was not bypassed even if the bypass IDs matched. Only one value is defined: 0x0001 – Unknown bypass ID for Default network adapter.
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 the caller’s user agent. See the UserAgent table in Lync Server 2013 for details.
CallerUserAgentCategory	nvarchar(64)	Category of the 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 in the caller’s endpoint.
CalleeCPUNumberOfCores	smallint	Number of CPU cores in 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.
CorrelationKey		Correlation key. Referenced from the SessionCorrelation table in Lync Server 2013.
ConnectivityIce	tinyint	Information about the 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	tinyint	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 interval 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 callee is inside the interval 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 used 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 used 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.
CallerRenderDriver	varchar(256)	Caller’s render device driver name.
CalleeCaptureDev	varchar(256)	Callee’s capture device name.
CalleeRenderDev	varchar(256)	Callee’s render device name.
CalleeCaptureDevDriver	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 the caller connected over a virtual private network: 1 is virtual private network (VPN), 0 is non-VPN.
CallerLinkSpeed	decimal(18,0)	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 the caller 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.
PacketLossRate	decimal(5,4)	Average packet loss rate during the call.
PacketLossRateMax	decimal(5,4)	Maximum packet loss observed during the call.
BurstDensity	decimal(9,4)	Average density of packet loss during bursts of losses during the call.
BurstDuration	int	Average duration of packet loss during bursts of losses during the call.
BurstGapDensity	decimal(9,4)	Average density of packet loss during gaps between bursts of packet loss.
BurstGapDuration	int	Average duration of gaps between bursts of packet loss.
PacketUtilization	int	Packet count for the audio stream.
BandwidthEst	int	Bandwidth estimates for the audio stream.
DegradationAvg	decimal(3,2)	Network MOS Degradation for the whole call. Range is 0.0 to 5.0. This metric shows the amount the Network MOS was reduced because of jitter and packet loss. For acceptable quality it should less than 0.5.
DegradationMax	decimal(3,2)	Maximum Network MOS degradation during the call.
DegradationJitterAvg	decimal(3,2)	Network MOS degradation caused by jitter.
DegradationPacketLossAvg	decimal(3,2)	Network MOS degradation caused by packet loss.
PayloadDescription	int	The audio codec used for the call, referenced from the PayloadDescription table in Lync Server 2013.
AudioSampleRate	int	Sampling rate for the audio stream.
CallerSendSignalLevel	int	Post-Analog Gain Control audio signal level for the audio the caller sent. The unit for this metric is dBmo. For acceptable quality, it should be at least 30 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CallerRecvSignalLevel	int	Audio signal level for the audio the caller received. The unit for this metric is dBmo. For acceptable quality, it should be at least 30 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CallerSendNoiseLevel	int	Post-Analog Gain Control audio noise level for the audio the caller sent. The unit for this metric is dBmo. For acceptable quality, it should be less than 35 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CallerRecvNoiseLevel	int	Post-Analog Gain Control audio noise level for the audio the caller received. The unit for this metric is dBmo. For acceptable quality, it should be less than 35 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CallerEchoReturn	int	Echo Return Loss Enhancement for the caller. The unit for this metric is dB. Lower values represent less echo. This metric is not reported by the A/V Conferencing Server or IP phones.
CallerSpeakerGlitchRate	int	Average glitches per five minutes for the caller’s loudspeaker rendering. For good quality, this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.
CallerMicGlitchRate	int	Average glitches per five minutes for the caller’s microphone capture. For good quality this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.
CallerTimestampDriftRateMic	decimal(9,2)	Caller’s microphone device clock drift rate, relative to CPU clock.
CallerTimestampDriftRateSpk	decimal(9,2)	Caller’s speaker device clock drift rate, relative to CPU clock.
CallerTimestampErrorMicMs	decimal(9,2)	Average microphone capture stream time stamp error, in milliseconds, in the last 20 seconds of the call.
CallerTimestampErrorSpkMs	decimal(9,2)	Average of the caller’s speaker render stream time stamp error, in milliseconds, in the last 20 seconds of the call.
CallerVsEntryCauses	smallint	Voice switch is a half-duplex mode with reduced interruption ability. See the MediaLine table in Lync Server 2013 for more information.
CallerEchoEventCauses	tinyint	Causes of an echo event for the caller. See the MediaLine table in Lync Server 2013 for more information.
CallerEchoPercentMicIn	decimal(5,2)	Percentage of time when echo is detected in the caller’s microphone capture stream. If headset is used, the value should be low.
CallerEchoPercentSend	decimal(5,2)	Percentage of time when echo is detected in the caller’s sent stream. High echo percentage in send streams an indication of echo leak.
CallerRxAGCSignalLevel	int	Received signal level on the Mediation Server from the Gateway for the caller’s audio; this applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be -30 to -18 dBoV.
CallerRxAGCNoiseLevel	int	Received signal level on the Mediation Server from the Gateway for the caller’s audio. This applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be less than -50 dBoV.
CallerRxAGCGain	int	Automatic gain control (AGC) on the Mediation Server side applied to the caller’s audio.
CallerInitialSignalLevelRMS	float	Root mean square (RMS) of the incoming signal to the caller for up to the first 30 seconds of the call.
CalleeSendSignalLevel	int	Represents the Post-Analog Gain Control audio signal level for the audio the callee sent. The unit for this metric is dBmo. For acceptable quality, it should be at least 30 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CalleeRecvSignalLevel	int	Audio signal level for the audio the callee received. The unit for this metric is dBmo. For acceptable quality, it should be at least 30 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CalleeSendNoiseLevel	int	Post-Analog Gain Control audio noise level for the audio the callee sent. The unit for this metric is dBmo. For acceptable quality, it should be less than 35 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CalleeRecvNoiseLevel	int	Post-Analog Gain Control audio noise level for the audio the callee received. The unit for this metric is dBmo. For acceptable quality, it should be less than 35 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
CalleeEchoReturn	int	Echo Return Loss Enhancement for the callee. The unit for this metric is dB. Lower values represent less echo. This metric is not reported by the A/V Conferencing Server or IP phones.
CalleeSpeakerGlitchRate	int	Average glitches per five minutes for the callee’s loudspeaker rendering. For good quality, this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.
CalleeMicGlitchRate	int	Average glitches per five minutes for the callee’s microphone capture. For good quality this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.
CalleeTimestampDriftRateMic	decimal(9,2)	Callee’s microphone device clock drift rate, relative to CPU clock.
CalleeTimestampDriftRateSpk	decimal(9,2)	Callee’s speaker device clock drift rate, relative to CPU clock.
CalleeTimestampErrorMicMs	decimal(9,2)	Average microphone capture stream time stamp error, in milliseconds, in the last 20 seconds of the call.
CalleeTimestampErrorSpkMs	decimal(9,2)	Average of the callee’s speaker render stream time stamp error, in milliseconds, in the last 20 seconds of the call.
CalleeVsEntryCauses	smallint	Voice switch is a half-duplex mode with reduced interruption ability. See the MediaLine table in Lync Server 2013 for more information.
CalleeEchoEventCauses	tinyint	Causes of an echo event for the callee. See the MediaLine table in Lync Server 2013 for more information.
CalleeEchoPercentMicIn	decimal(5,2)	Percentage of time when echo is detected in the callee’s microphone capture stream. If headset is used, the value should be low.
CalleeEchoPercentSend	decimal(5,2)	Percentage of time when echo is detected in the callee’s sent stream. High echo percentage in send streams an indication of echo leak.
CalleeRxAGCSignalLevel	int	Received signal level on the Mediation Server from the Gateway for the callee’s audio; this applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be [-30 to -18] dBoV.
CalleeRxAGCNoiseLevel	int	Received signal level on the Mediation Server from the Gateway for the callee’s audio. This applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be less than -50 dBoV.
CalleeRxAGCGain	int	Automatic gain control (AGC) on the Mediation Server side applied to the callee’s audio.
CalleeInitialSignalLevelRMS	float	Root mean square (RMS) of the incoming signal to the callee for up to the first 30 seconds of the call.
RatioConcealedSamplesAvg	decimal(5,2)	Average ratio of concealed samples generated by audio healing to typical samples.
RatioStretchedSamplesAvg	decimal(5,2)	Average ratio of stretched samples generated by audio healing to typical samples.
RatioCompressedSamplesAvg	decimal(5,2)	Average ratio of compressed samples generated by audio healing to typical samples.
RoundTrip	int	Round trip time from RTCP statistics.
RoundTripMax	int	Maximum round trip time for the audio stream.
OverallAvgNetworkMOS	decimal(3,2)	Average wideband Network MOS for the call. This metric depends on the packet loss, jitter, and codec used. Range is 1.0 to 5.0.
OverallMinNetworkMOS	decimal(3,2)	Minimum wideband Network MOS for the call.
SendListenMOS	decimal(3,2)	Average predicted wideband Listening MOS score for audio sent, including speech level, noise level and capture device characteristics.
SendListenMOSMin	decimal(3,2)	Minimum SendListenMOS for the call.
RecvListenMOS	decimal(3,2)	Average predicted wideband Listening MOS score for audio received from the network including speech level, noise level, codec, network conditions and capture device characteristics.
RecvListenMOSMin	decimal(3,2)	Minimum RecvListenMOS for the call.
AudioFECUsed	bit	Indicates whether audio FEC was used for the call.
SenderIsCallerPAI	bit	Indicates direction of the p-asserted identify 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.