[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