How do I pull call logs from phones

Unanswered Question
Feb 27th, 2008
User Badges:

We are having a 911 hangup problem, so far I can not catch the calls in CDR as they are incomplete. The only way to find the caller is to go to each phone and look at the PLaced Call log in the directories.

Can I do this remotely- without going to each phone?

Thanks,\

Andy

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Rob Huffman Wed, 02/27/2008 - 11:13
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Andy,


Here is an example that shows tracing 911 calls;


Using SQL Queries to Search the Call Detail Record with Cisco CallManager


Search for Calls Made to a Specific Number


In some situations, you might need to find out the extension which called 911 on a specific date. Complete these steps in order to search for calls made to a specific number such as 911.


In order to search for calls that are made to a specific number, you can run a different query.


For example, if you want to look for calls to 911 you can enter the query select * from CallDetailRecord where finalcalledpartynumber='911'.


The bottom of the page displays all the entries in the CDR that have the final called party number equal to 911.


Add a date to this query in order to refine it.


For example, for all calls to 911 after August 1st, 2003, run the query select * from CallDetailRecord where finalcalledpartynumber='911' and datetimeconnect > '1059696000'.


The bottom of the page displays all the entries in the CDR that have the final called party number equal to 911 made after August 1st, 2003. '1059696000' is the universal time in seconds for August 1st, 2003.


In order to see who calls 911, run the query select callingpartynumber from CallDetailRecord where finalcalledpartynumber='911'.


From this doc;


http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml


Hope this helps!

Rob



averheaghe Wed, 02/27/2008 - 12:50
User Badges:

I have attempted to use the SQL queries, but it is not tracking incomplete calls.

The problem is we have a user or users who dial 911 and hangup imediately, yet the gateway is sending out the call. 911 answers but no one is on the other line.


Paolo Bevilacqua Wed, 02/27/2008 - 13:15
User Badges:
  • Super Gold, 25000 points or more
  • Hall of Fame,

    Founding Member

Which type of lines to pstn do you have ?


One possible solution would be permanent debug on the gw, and capture to syslog server.


averheaghe Thu, 02/28/2008 - 08:45
User Badges:

The Gateway is a 2821, with PRI.

We are loggin activity from the gateway to a syslog server, do the logs track the calling extension- or just the called party?

Rob Huffman Wed, 02/27/2008 - 13:53
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Andy,


The calls you are looking for would be referred to as "Zero Duration Calls" which by default are not collected. You should set this parameter;


CDR-Related Service and Enterprise Parameters


The following service parameters apply to CDRs:


Max CDR Records - Cisco Database Layer Monitor service parameter that controls the maximum number of CDRs on the system. When this limit is exceeded, the oldest CDRs automatically get removed, along with the related CMR records, once a day. The default specifies 1.5 million records.


CDR Enabled Flag - Cisco CallManager service parameter that controls whether CDRs are generated. Set this parameter on each Cisco CallManager in the cluster. You do not need to restart the Cisco CallManager for the change to take effect.


**CDR Log Calls With Zero Duration Flag - Cisco CallManager service parameter that controls whether calls with zero duration are logged in CDRs. The default specifies False (zero duration calls not logged).


Call Diagnostics Enabled - Cisco CallManager service parameter that controls whether call diagnostic records containing QoS information about calls are generated. The default specifies False (diagnostics not generated).


http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_administration_guide_chapter09186a00803edb2b.html#wp1030955



Hope this helps!

Rob



Paolo Bevilacqua Wed, 02/27/2008 - 14:03
User Badges:
  • Super Gold, 25000 points or more
  • Hall of Fame,

    Founding Member

Not having a clue about CM, I've easily took the wrong route in suggesting a solution.

My '5' points to Rob's post above!

Rob Huffman Wed, 02/27/2008 - 16:29
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Paolo,


Thanks buddy :) Don't ever sell yourself short on knowledge. You Rock!


Take care,

Huff

averheaghe Thu, 02/28/2008 - 08:43
User Badges:

My Zero duration flag is set to true.

Everything says I should be collecting these, but they are not being caught at the CCM.

So far my only way to find them has been to visit each phone.

israellopezv Mon, 03/03/2008 - 21:42
User Badges:

Do you have a publisher and subscriber CCM? That bit me once already when I was deploying call accounting software.


Check if they both have the settings, they should match.


http://ilopez.com/bl/?p=35

averheaghe Mon, 03/10/2008 - 14:04
User Badges:

I do have both a pub and sub, only the pub collects the CDRs and I do not see a way to enable it on the sub.

israellopezv Tue, 03/11/2008 - 09:00
User Badges:

You can only do it in the Enterprise Services Area in CCM Administrator. Do you have the option of configuring the other CCM? Screenshot it and I can help you.

Actions

This Discussion