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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

cdr and 911 calls

Does anyone know a way to use the cdr analyst tool to find out who made calls to a specific number say 911 for example?

1 REPLY
Bronze

Re: cdr and 911 calls

Please follow this steps to run a query to check who called 911

start > programs > Microsoft SQL server > Query Analyzer > select "Windows

authentication" and click on OK > on the new displayed window, at the top

of the page, select the CDR database from the drop-down list > then paste

the following query:

select callingPartyNumber,dateTimeOrigination from CallDetailRecord where

finalcalledpartynumber='911'

Then just click on the green arrow icon (it is located at the top of the

page) to execute it.

The displayed columns will provide the following information:

-callingPartyNumber (dialing extension)

-dateTimeOrigination (time of call)

To find out the time of the call, obtain the information from the

"dateTimeOrigination" column. The value is a coordinated universal

time (UTC) value, and represents the number of seconds since Midnight

(000000) January 1, 1970.

596
Views
0
Helpful
1
Replies