Good morning, I have a problem in one of our texas offices. Apparently a number of people are having problems dialing 911. Definitely because of the country code, considering they call mexico and central/south america regularly. My manager has requested a report to identify only calls placed to 911 and the origination point. Any help is greatly appreciated. Thank you to all in advance.;)
This is the only method that I know of to do this type of search (in CCM);
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'.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...