How can I find out who dialed 911 in CM 6

Unanswered Question
honniesr Tue, 10/07/2008 - 12:28

You can wait until after midnight(after CDR reports are processed), then go to your call manager's CAR site http://iphere/car/login.asp

login with your car administrator login, then choose export CDR records. It exports your entire call history into a csv file that you can then import into excel/access.

HTH

Thanks,

Robert

bsieber39 Fri, 11/14/2008 - 11:40

you can do it in "almost" real time. export your CDR records then import them into a sql database. use the following sql query to find the extension

DECLARE @StartDateTime DATETIME

,@EndDateTime DATETIME

SELECT @StartDateTime = '11/11/2008 08:00'

SELECT @EndDateTime = '11/12/2008 23:00'

select callingPartyNumber,originalCalledPartyNumber,finalCalledPartyNumber,globalCallID_callId,

duration,origCalledPartyRedirectReason,lastRedirectRedirectReason,

datetimeorigination = DATEADD(hour,-5,(dateadd(second ,dateTimeOrigination, '1/1/1970')))

,datetimedisconnect = DATEADD(hour,-5,(dateadd(second ,dateTimedisconnect, '1/1/1970')))

from cdr --this is the table you imported data into--

where finalcalledpartynumber = ('911')

AND DATEADD(hour,-4,(dateadd(second ,dateTimeOrigination, '1/1/1970'))) >= @StartDateTime

AND DATEADD(hour,-4,(dateadd(second ,dateTimeOrigination, '1/1/1970'))) <= @EndDateTime

order by datetimedisconnect

Actions

This Discussion