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

How to extract 911 report from Call Manager

Hi, It has been requested I provide a report showing only 911's and where they are originating. Does Call Manager have a utility I can use to extract this data?

Thanks to all in advance, it is greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Hall of Fame Super Red

Re: How to extract 911 report from Call Manager

Hi Ross,

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

From this doc;

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

Hope this helps!

Rob

Please remember to rate helpful posts.....

5 REPLIES
Blue

Re: How to extract 911 report from Call Manager

You can use CAR (CDR Analysis & Reporting). Just do a search on 911 (or 9911 if users dial a 9 access) for the dates you are interested. You will get the originating number and the time.

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_administration_guide_chapter09186a00803f5268.html

Please rate helpful posts.

Community Member

Re: How to extract 911 report from Call Manager

Hi, thank you for responding.

The search facility has only default functionality:

By User/Extension

By Gateway

By Cause for call termination

By Call Precedence level

Malicious call

It doesn't have an open criteria option.

Blue

Re: How to extract 911 report from Call Manager

When you search by extension, that number can be either the calling number or the called number. This is where you would put the 911.

I have used this to identify what internal DN placed a 911 call.

Blue

Re: How to extract 911 report from Call Manager

We moved a group of users to a different site yesterday, and so the techs were supposed to do a test 911 call.

To verify I did a CAR search on 911 for yesterday. The test call was there, as well as a surprising number of misdialed calls where the user had dialed 911 and gotten the "your call can not be completed as dialed".

We dial a 9 access code for all calls including 911. The CAR search shows that if we allowed users to dial either 911 or 9911 (some places have regulations mandating that)there would be a lot of false 911 calls. Perhaps that is your situation?

Hall of Fame Super Red

Re: How to extract 911 report from Call Manager

Hi Ross,

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

From this doc;

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

Hope this helps!

Rob

Please remember to rate helpful posts.....

3754
Views
0
Helpful
5
Replies
CreatePlease to create content