We've had call manager (ver 18.104.22.168) now for 2 months and since the migration I have had folks accidently dialing 911 on a daily basis. Rather than stay on the line and explain they dialed 911 by mistake, my folks are hanging up. I can search the cdr database and find the offenders, but unfortunately the cdr database is a day behind so I can not search for calls made during the current day.
How can I find who just dialed a number within the past few minutes?
Good question. There are two methods available to you (well, two that I can think of):
1. Setup a "billing" server to receive the CDR feed from your cluster. The files will be text files that are sent every X minutes. Where X is configured in the Enterprise Parameters (CDR Polling Interval, I think that is the param). These will be text files and you would need to parse them. There are data dictionaries available on CCO.
2. You can run a query directly on the console of the server. It won't be exactly "real time" but it will be close. I believe the Enterprise Parameter for CDR polling comes into play here as well. Anyway, the command:
admin: run sql select datetimeorigination,callingpartynumber,originalcalledpartynumber from car:tbl_billing_data where originalcalledpartynumber = '911' order by datetimeorigination
Now, the datetimeorigination will be in Unix or Epoch time, so you may need to take an extra step to line up the date/time. You can use a site like this one: http://www.epochconverter.com/
You can get the epoch time for the range you are interested in and then add the date/time parameters to the where clause of your query.
I tried your second suggestion and I get the same results as a CDR search through UCM CDR and Reporting web page (but a lot less data and much cleaner). For some reason the tbl_billing_data table is not populated with cdr data until one day later. Any idea where I may find the CDR polling interval setting?
I made sure the scheduler is set to continuous 24x7.
You should be able to get CDR information almost realtime. If you are getting CDR records one day behind is becaue your CAR scheduler is setup only to run during a specific window late at night, however if you configure 24x7 loading you should be getting records just a minutes after a call is made.
Check the scheduler setting inside CAR utility to make sure is 24x7
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
[toc:faq]CUCM Database Replication is an area in which Cisco customers
and partners have asked for more in-depth training in being able to
properly assess a replication problem and potentially resolve an issue
without involving TAC. This document discusse...