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

Wes Sisk wsisk at cisco.com
Wed Sep 12 13:39:48 EDT 2007


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

/Wes


Robert Kulagowski wrote:
> CM 4.1.3sr2
>
> I'm trying to calculate MOS for one of my sites (VM calls to Unity over 
> the WAN)
>
> When I looked in CAR, it appears that I'll only get "Good" "Acceptable", 
> etc, which isn't what I'm looking for - I really need to have some number.
>
> Using the data that's in the SQL database, I should be able to do a SQL 
> query to pull the calls from the site that go do VM, but how do I 
> correlate that to the records that details jitter, etc?  I can't seem to 
> find the thread that ties the CallDetailRecord table with the one that 
> actually stores the raw data.
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>   


More information about the cisco-voip mailing list