01-14-2014 01:49 PM - edited 03-16-2019 09:14 PM
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.
Solved! Go to Solution.
01-14-2014 02:40 PM
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.
01-14-2014 02:02 PM
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
01-14-2014 02:08 PM
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')
01-14-2014 02:23 PM
I ran that command and I'm not getting any results through the CLI. Just a lot of ====== ===== ===== with no other information.
01-14-2014 02:33 PM
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.
01-14-2014 02:40 PM
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.
01-14-2014 04:37 PM
Thanks for all of the help
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide