Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Logging 911 Calls - Pulling up historical call history

We have had a few times in the past few months where we are getting 911 calls and do not know where the calls originated.  We need to know if these are accidental calls or if someone is coming in through the system.  We have transfer rules setup in the Unity server for when people come in through the auto attendant and I tested calling 9.911 and 911 from there and neither went through.  We have setup CDR after the fact but I'm not seeing any options in there that would show us the calling directory and called number. 

Any help is much appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Logging 911 Calls - Pulling up historical call history

That query is just another way of looking in the CAR database, so if the data for the call isn't in the database, you would not see any results, as you experienced.

6 REPLIES
Hall of Fame Super Silver

Logging 911 Calls - Pulling up historical call history

CUCM CDR will show you all the details, make sure you set your service parameter to log CDR and CDR records with 0 duration.

HTH,

Chris

New Member

Re: Logging 911 Calls - Pulling up historical call history

If you have access to the CUCM command line interface, you can run a SQL query to identify the extension that placed the call.  Assuming you have CUCM version 8 or later, and are using 9 as your PSTN access code, the following SQL query should get you what you are looking for (this is entered as one line, with no carriage returns):

run sql car select callingpartynumber,originalcalledpartynumber,finalcalledpartynumber, datetimeorigination from tbl_billing_data where originalcalledpartynumber IN ('911','9911') or finalcalledpartynumber IN ('911','9911')

New Member

Logging 911 Calls - Pulling up historical call history

I ran that command and I'm not getting any results through the CLI.  Just a lot of ====== ===== ===== with no other information.

New Member

Logging 911 Calls - Pulling up historical call history

Could this not be displaying because the CDR service was not running when the 911 call occurred.  I ran another call through the sql script you gave and it did yield a result.

New Member

Logging 911 Calls - Pulling up historical call history

That query is just another way of looking in the CAR database, so if the data for the call isn't in the database, you would not see any results, as you experienced.

New Member

Logging 911 Calls - Pulling up historical call history

Thanks for all of the help

153
Views
10
Helpful
6
Replies
CreatePlease login to create content