Need to retrieve call information

Unanswered Question
Jun 12th, 2007
User Badges:

We have a client. THey are a highschool. Someone made a call to 911 at exactly 12:08 pm. I am trying to identify and get the call information. I need to try to identify who made that call. Well at least from which ip phone extension.

We are running call manager 4.0.2. Any assistance will help.

Thank you

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (2 ratings)
Majdi Harb Tue, 06/12/2007 - 09:51
User Badges:
  • Silver, 250 points or more

u can use (RTMT) a client side standalone plugin runs as an application using HTTP and TCP to monitor a set of management objects that are preconfigured, it also can generates daily reports and u can view syslogs for these objects from within is the call activities.


please remember to rate helpful posts


Rob Huffman Tue, 06/12/2007 - 11:27
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Shir,

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;

Hope this helps!


mickeyhunt Tue, 06/12/2007 - 15:07
User Badges:

Open your CCM log for that time frame and do a search for 911 and it will show you the extension of the caller.


This Discussion