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

Attention: The Cisco Support Community site will be in read only mode on Dec14, 2017 from 12:01am PST to 11:30am for standard maintenance. Sorry for the inconvenience.

New Member

Call Logs

All,

We have been having 911 hangups lately. I'm trying to figure out if anyone has dialed 911 from our CCM4.x voice system. Is there a way to log outbound calls? Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Hall of Fame Super Red

Re: Call Logs

Hi Ian,

Here is an example that shows tracing 911 calls;

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'.

From this doc;

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml

Hope this helps!

Rob

2 REPLIES

Re: Call Logs

Hello,

Check this link:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/4_2_3/ccmsrva/sacar1.html')">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/4_2_3/ccmsrva/sacar1.html

Then look at the section: CDR Search Configuration

Hope that helped, if so please rate.

Hall of Fame Super Red

Re: Call Logs

Hi Ian,

Here is an example that shows tracing 911 calls;

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'.

From this doc;

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml

Hope this helps!

Rob

274
Views
3
Helpful
2
Replies
CreatePlease to create content