Tracing 911 call

Answered Question
May 12th, 2009
User Badges:

Can somebody advise me on the best way to trace 911 calls coming from inside our facility - we are running CUCM 6.1(2) so no SQL DB to look at. This has happened multiple times but we cannot seem to find what extension is dialing it.

Thanks in advance!!

Correct Answer by Jaime Valencia about 7 years 11 months ago

CAR is a good option, you still can run qrys to informix DB via the CLI


ie


run sql select * from car:tbl_billing_data where originalcalledpartynumber='911'


HTH


java


if this helps, please rate

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Jaime Valencia Tue, 05/12/2009 - 13:05
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

CAR is a good option, you still can run qrys to informix DB via the CLI


ie


run sql select * from car:tbl_billing_data where originalcalledpartynumber='911'


HTH


java


if this helps, please rate

pcaltagirone22 Wed, 05/13/2009 - 07:56
User Badges:

Thanks very much! Great info.

Is there a clean way to export that data into some type of spreadsheet?

tgledbetter Fri, 05/29/2009 - 05:05
User Badges:

Hi javalenc; is there a good Cisco doc explaining CLI queries for CDR lookups on 6.1?

lupemacias Tue, 05/12/2009 - 15:43
User Badges:

I've also recently moved to 6.1(2). I was running 4.1(3) and had it sending my CDRs to a SQL server making it easy for me to search for calls. The upgrade broke my setup and I was faced with either purchasing ER or IPcelerate for 911 call notification.


After playing with CCM for a while, I was able to configure it to ftp the CDR records to another server. I then wrote a simple app that would get the uploaded CDR files and upload them to my SQL server. While the program is processing the CDR files, it keeps a lookout for 911 calls. If the app finds a call that is no older than 5 minutes it sends an email to a list of predefined uses.

Actions

This Discussion