cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
704
Views
0
Helpful
1
Replies

cdr and 911 calls

whanson
Level 2
Level 2

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 1

neesharm
Level 1
Level 1

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.