|
Home > Archive > Voice over IP Cisco > September 2007 > Calculating MOS using CAR / CDR / SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calculating MOS using CAR / CDR / SQL
|
|
| Robert Kulagowski 2007-09-11, 7:11 pm |
| 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.
| |
| Wes Sisk 2007-09-12, 1:11 pm |
| 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...>
806556fb.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@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| Robert Kulagowski 2007-09-12, 7:11 pm |
| 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...>
806556fb.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.
| |
|
|
|
|
|