Consultas de base de datos de QoE de ejemploSample QoE database queries

Esta sección contiene ejemplos de consultas de la base de datos de calidad de la experiencia (QoE).This section contains sample queries for the Quality of Experience (QoE) database.

Utilice el ejemplo siguiente para obtener el promedio la inestabilidad y pérdida de paquetes para todas las secuencias de audio.Use the following example to get the jitter and packet loss average for all audio streams.

select avg(cast(JitterInterArrival as bigint)) as JitterAvg, avg(PacketLossRate) as PacketLossRateAvg from AudioStream

Utilice el siguiente ejemplo para encontrar el número total de conferencias que utilizan la consola de reunión.Use the following example to find the total numbers of conferences that used Meeting Console.

select avg(ConversationalMOS)
from SessionView s
inner join MediaLineView m
on s.ConferenceDateTime = m.ConferenceDateTime
   and s.SessionSeq = m.SessionSeq
   and m.MediaLineLabel = 0 -- audio media line
   and s.CallerUserAgentType = 4 -- Lync
   and s.CalleeUserAgentType = 4 -- Lync

Utilice el siguiente ejemplo para obtener ConversstionalMOS, SendingMOS y ListendingMOS por el dispositivo de captura.Use the following example to get ConversstionalMOS, SendingMOS and ListendingMOS per capture device.

select t.DeviceName as Device, count(*) as SampleNum, avg(ConversationalMOS) as ConversationalMOS, avg(SendListenMOS) SendingMOS, avg(RecvListenMOS) as ListendingMOS
from
(
   select m.CallerCaptureDev as DeviceName, m.ConferenceDateTime, m.SessionSeq, a.StreamID, m.ConversationalMOS,a.SendListenMOS, a.RecvListenMOS
   from MediaLineView m
   inner join AudioStream a
   on m.ConferenceDateTime = a.ConferenceDateTime
      and m.SessionSeq = a.SessionSeq
      and m.MediaLineLabel = 0

   union

   select m.CalleeCaptureDev as DeviceName, m.ConferenceDateTime, m.SessionSeq, a.StreamID, m.ConversationalMOS,a.SendListenMOS, a.RecvListenMOS
   from MediaLineView m
   inner join AudioStream a
   on m.ConferenceDateTime = a.ConferenceDateTime
      and m.SessionSeq = a.SessionSeq
      and m.MediaLineLabel = 0

)as t
group by t.DeviceName
order by SampleNum desc