911 CDR search before CDR's are uploaded to ART

Unanswered Question
Feb 23rd, 2004
User Badges:

Ever want to know who called 911 very quickly. Create a file called E911.sql, and associate .sql with c:\program files\Microsoft SQL Server\80\tools\isqlw.exe. Then add the following to E911.sql:


USE CDR

SELECT DATEADD(ss, dateTimeOrigination - 21600, '19700101') AS dateTimeOrgination, callingPartyNumber, finalCalledPartyNumber, duration, origDeviceName,

destDeviceName, dateTimeOrigination

FROM CallDetailRecord

WHERE (finalCalledPartyNumber = '911') OR

(finalCalledPartyNumber = '9911')

ORDER BY dateTimeOrigination DESC

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Actions

This Discussion