[cisco-voip] CCM Traces

[Jack Martin]

Use this SQL query to find out who called 911:

 

SELECT     *

FROM         CallDetailRecord

WHERE     (originalCalledPartyNumber = '911')

 

Jack Martin, CCVP

Network Engineer

Tushaus Computer Services

10400 Innovation Drive, Ste 100

Milwaukee, WI 53226

414.908.2222 Helpdesk

414.908.2267 Work

414.908.4467 Fax

414.477.6990 Cell

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Wes Sisk
Sent: Monday, December 17, 2007 11:56 AM
To: CarlosOrtiz at bayviewfinancial.com
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CCM Traces

 

Hi Carlos,
For CDR it depends on how the call was cleared. If call terminated
abnormally (not simple onhook) then it will always be recorded in CDR.
If user hung up to terminate the call then the call would not be
recorded in CDR if it did not reach the connected state.
If call reached the connected state for more than 1 second before user
disconnected it will appear in CDR.

Ususally accidental 911 calls are hungup in the proceeding or alerting
state so normally they are not logged by CDR.

If you have the CM service parameter "CDR log calls with zero duration"
set True then all subsequent calls will be logged regardless of duration
or state.


Otherwise, take your ccm*.txt traces and search for 
dd="911"

or whatever your emergency pattern is.

/Wes

CarlosOrtiz at bayviewfinancial.com wrote: 


I am looking through the archives and see there are queries for finding
911 calls in the CDR database.  However, I believe if the call is too
short the call does not appear in the CDR database.  I was told by my
manager that a former emplyee would enable a CCM trace that was able to
track the 911 dialer even if it didn't appear in CDR.  Anyone know which
one? 

Carlos 

 


________________________________



 
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20071218/b3ef5a83/attachment.html