[cisco-voip] search 911 call via CAR (CUCM 7)

[Wes Sisk]

CAR cdr search may not search the error table.  I believe this will work 
from the CLI on the publisher:

run sql car select 
callingpartynumber,origdevicename,finalcalledpartynumber from 
tbl_billing_data where finalcalledpartynumber like '%911'

run sql car select 
callingpartynumber,origdevicename,finalcalledpartynumber from 
tbl_billing_error where finalcalledpartynumber like '%911'


Note the 2 queries hit 2 different tables.

Regards,
Wes

On 4/15/2011 2:10 PM, Burnam, William wrote:
>
> Hello All,
>
> I'm having a constant problem with users dialing 911 (by accident it 
> seems).  I need to pull records from CAR to show everyone in the 
> system that has dialed 911, but I'm not having any luck.  I can search 
> by a user's extension and then sort through the records until I find 
> the CDR record that shows the 911 call, but I'm not sure how I can 
> simply search for ALL calls (all users) to 911 only.  For reference 
> I'm using CUCM 7.  Can anyone help out with this?
>
> Thanks,
>
> Bill
>
> Description: cid:image001.jpg at 01CACCCA.108F0930
>
> Bill Burnam
>
> Systems Engineer, IT
>
> MAPEI Corp.
>
> 1144 E. Newport Center Drive
>
> Deerfield Beach, FL 33442
>
> (954) 246-8703
>
> _CONFIDENTIALITY NOTICE_
>
> THIS COMMUNICATION, INCLUDING ANY ATTACHMENT, CONTAINS INFORMATION 
> THAT IS CONFIDENTIAL AND THAT MAY ALSO BE LEGALLY PRIVILEGED, AND IS 
> INTENDED ONLY FOR THE EXCLUSIVE USE OF THE INDIVIDUAL NAMED AS THE 
> RECIPIENT.  IF THE READER OF THIS MESSAGE IS NOT THE INTENDED 
> RECIPIENT, YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR AND ANY 
> REVIEW, DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION 
> OR ANY ATTACHMENT TO THIS TRANSMISSION IS STRICTLY PROHIBITED.  IF YOU 
> HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE IMMEDIATELY NOTIFY 
> THE SENDER BY REPLY E-MAIL AND DELETE AND DESTROY ALL COPIES OF THE 
> ORIGINAL MESSAGE.  THANK YOU.
>
>
>
>           ------------------------------------------------------------------------
>           ------------------------------------------------------CONFIDENTIALITY
>           NOTICE ----------------------------------------------------
>           THIS COMMUNICATION, INCLUDING ANY ATTACHMENT, CONTAINS
>           INFORMATION THAT IS CONFIDENTIAL AND IS INTENDED ONLY FOR
>           THE EXCLUSIVE USE OF THE INDIVIDUAL NAMED AS THE RECIPIENT.
>           IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT,
>           YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR AND ANY REVIEW,
>           DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION
>           OR ANY ATTACHMENT TO THIS TRANSMISSION IS STRICTLY
>           PROHIBITED. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR,
>           PLEASE IMMEDIATELY NOTIFY THE SENDER BY REPLY E-MAIL AND
>           DELETE AND DESTROY ALL COPIES OF THE ORIGINAL MESSAGE. THANK
>           YOU.
>           ------------------------------------------------------------------------
>
>
> _______________________________________________
> 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/20110415/3886d925/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2898 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110415/3886d925/attachment.jpe>