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

Robert Kulagowski rkulagow at gmail.com
Tue Sep 11 17:03:28 EDT 2007


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.


More information about the cisco-voip mailing list