neesharm Tue, 05/22/2007 - 20:04
User Badges:
  • Bronze, 100 points or more

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.


Actions

This Discussion