Export "missed calls"-List from one DN on CCM 4.1.3?

Unanswered Question
Oct 22nd, 2008
User Badges:

Hi together,


My Supervisor wants a printed List of all missed calls for his DN from the last week.

Is it possible to get a file or something which includes a list of the missed calls for his DN ?

We do not use CDR, and I think die place where the missed calls are stored is the IP-Phone, so that I have almost no chance to get a List.


Kind regards


Christian

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Rob Huffman Wed, 10/22/2008 - 05:40
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Christian,


As you most correctly noted, the Missed Calls List (Call History) is stored on the IP Phone itself so there is no method to retrieve this list/report for your Supervisor. This would have to be manually copied (one by one) from the actual phone.


Sorry man! Hope this helps!

Rob

christianluven Wed, 10/22/2008 - 05:44
User Badges:

Hi,


Yes this helps to harden my thoughts :-)

I thought maybe there's a way with log-files or traces or something....


greetings


Christian


Steffen.Baier Wed, 10/22/2008 - 05:55
User Badges:

It all also depends how the call manager is setup to handle any CDR records. There is a way to query the SQL CDR Database but unanswered incoming calls seem not to appear.


I tried it on my Dev System but may need some more tweaking.



There is a document on the Cisco website explaing how to use this.


select * from CallDetailRecord

where dateTimeConnect > '973995954' were the datetimeconnect is in Unix time.


Above us for all calls made after a date.


For between dates:


select * from

CallDetailRecord where dateTimeConnect > '973995954' and datetimeconnect < '1063574868'


http://www.onlineconversion.com/unix_time.htm


You will need to use SQL Query analyzer and then in there select the CDR database


Actions

This Discussion