« Back to Call Detail Records Questions

RE: Re: New Message from Shivinder Singh in Serviceability XML (SXML) - Cal

Combination View Flat View Tree View
Threads [ Previous | Next ]
VoiceMail-left indicator in CDR?
cdr callmanager voice mail
Answer
10/3/12 1:35 PM
I have a project to do a very basic CDR analysis and reporting - placed/received calls by number/call center. I have things moving so far with CDR flat files coming into SQL Server on a schedule, and getting reports using C#/SQL.
So far I have noticed HuntPilotDN field tells me whether or not the call was fwd'ed to the phone's voice mail. But I need to go one step further - whether or not the caller LEFT a voicemail. Is the possible through CDR. And if not, what is the next best way?
version CUCM 8.0
Flag

Re: New Message from Shivinder Singh in Serviceability XML (SXML) - Call De
Answer
10/3/12 10:10 PM as a reply to Shivinder Singh.
If the voice mail system is Cisco Unity Connection, there is the CUMI
API, designed to allow applications to receive notifications of, browse,
and access voice mails:

http://developer.cisco.com/web/cuc/home

Note, the HuntPilotDN is not a 100% indication of voice mail, unless you
already know the hunt pilot for the VM system is part of the call flow.
Hunt groups/pilots can be configured for other things (like phone pools)
as well, and the HuntPilotDN would have a value for those call flows.

You might be able to try some forensic tricks, like checking to see if
the call eventually went to a VM-associated DN where messages are known
to be recorded, or comparing the length of the call with the length of
the voice mail greeting (longer calls suggest a message was left.)
These are not going to be be fully reliable howerver, of course.
Flag

RE: Re: New Message from Shivinder Singh in Serviceability XML (SXML) - Cal
Answer
10/4/12 4:35 PM as a reply to David Staudt.
David, this was exactly what I was looking for. I had no idea this API exists. CUMI precisely: http://docwiki.cisco.com/wiki/Cisco_Unity_Connection_Messaging_Interface_(CUMI)_API
I am taking my question on that API's forum.
http://developer.cisco.com/web/cuc/forums/-/message_boards/message/7344316?p_p_auth=p5otNpUK
 
EDIT: BTW - We have a well known number dedicated for voicemail, so I do check if HuntPilotDN is that number, it means caller was fwd'ed to voicemail.
Flag

RE: Re: New Message from Shivinder Singh in Serviceability XML (SXML) - Cal
Answer
10/31/12 11:18 PM as a reply to Shivinder Singh.
Dear Shivinder Sing,
I need you support because I'm developing a basic C# report system that show few information from a CDR-csv dump imported into SQL.
I have problem to calculate the call duration, calling number e called number etc...
 
Can you give me a little help to understand how correlate record in CDR-csv dump?
I already read each document that I found but without success.
 
Thanks in advance.
Flag

RE: Re: New Message from Shivinder Singh in Serviceability XML (SXML) - Cal
cdr .net call time csv duration
Answer
11/1/12 4:12 PM as a reply to Giorgio Zanoni.
Hi Giorgio Zanoni
Assuming you have CSV records in a database with matching column names,
 - call duration is in the duration field (in seconds)
 - calling number is in the callingPartyNumber field (I've seen 4 digit - internal, 10 digit - US, 12 digit - Intl. - numbers in this field)
 - called number depends - originalCalledPartyNumber, finalCalledPartyNumber and huntPilotDN are 3 places to check (that I know of)
 - call time is in dateTimeOrigination field (seconds elapsed since January 1st, 1970)
Quick C# code for:
 - converting call time: DateTime call_time = (new DateTime(1970,1,1)).AddSeconds(Convert.ToDouble(dateTimeOrigination));
 - getting duration: TimeSpan timespan_duration = new TimeSpan(0, 0, int.Parse(duration));
Flag