[cisco-voip] Calculating MOS using CAR / CDR / SQL

[Robert Kulagowski]

Wes Sisk wrote:
> yes, this is a pseudo classification that CAR applies based on jitter, 
> packet loss, etc.  It examines the stats for the call to reach this value.
> 
> later versions of CM get a true MOS calculation from the phones in the 
> CDR/CAR database in table calldetailrecorddiagnostics in columns 
> origvarVQMetrics and destvarVQMetrics
> 
> sample value:
> MLQK=4.5000;MLQKav=4.5000;MLQKmn=4.5000;MLQKmx=4.5000;ICR=0.0000;CCR=0.0000;ICRmx=0.0000;CS=0;SCS=0;MLQKvr=0.95 
> 
> 
> for 4.x use the CDR definitions doc to correlate rows beteween 
> calldetailrecord and calldetailrecorddiagnostic:
> http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/products_programming_usage_guide09186a00806556fb.html 

Hrmm, I'm getting bogus information that's making this harder.  When I 
did a select * from CallDetailRecordDiagnotic where latency > 0

I only received 573 rows.  I would have thought that _every_ call would 
would have > 1 latency, so this seems low.

A WAN call should have latencies in the 60-100ms range for these sites.