[cisco-voip] Who called 911 How Do You Access This Page?

Tue Feb 13 08:39:44 EST 2007

We use Excel to read out the CDR Data from Execl. I think its the easiest
way to work with the CDR Data. Just set up a ODBC Connection to CallManager
Log in and you get the Data. You can also define Filters and selct what you
want to see. A very easy way.

http://www.cisco.com/univercd/cc/td/doc/product/voice/vpdd/cdd/4_2/4_2_1/cdr
421.pdf

Reto 

Original Message:
-----------------
From: Dan Greenway Dan.Greenway at 2e2.com
Date: Tue, 13 Feb 2007 13:01:35 -0000
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Who called 911 How Do You Access This Page?

CAR needs to be installed

Dan

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Miller, Steve
Sent: 13 February 2007 12:59
To: Erick Bergquist; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Who called 911 How Do You Access This Page?

 I can't find the "CDR Tools and Analysis" page or anything that actual
searches for a dialed number.

Steve Miller
Telecom Engineer
Dickstein Shapiro LLP
1825 Eye Street NW | Washington, DC 20006
Tel (202) 420-3370 Fax (202)-330-5607 millers at dicksteinshapiro.com 

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Erick Bergquist
Sent: Tuesday, February 13, 2007 12:08 AM
To: Jason Burwell; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Who called 911

You can use CDR Tools And Analysis web page and do a CDR Search for 911
or 9911, that searches called and calling party numbers but only
displays 100 records. 

Or this SQL Query, replace 911 with 9911 if you use that or combine
them.

USE
CDR
SELECT callingPartyNumber,originalCalledPartyNumber,
finalCalledPartyNumber, duration

FROM CallDetailRecord

WHERE (((originalCalledPartyNumber)="911"))

----- Original Message ----

From: Jason Burwell <BurwellJ at firstcharter.com>

To: cisco-voip at puck.nether.net

Sent: Monday, February 12, 2007 3:20:11 PM

Subject: [cisco-voip] Who called 911

                                       <!--    /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal  	{margin:0in;
margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";}
a:link, span.MsoHyperlink  	{color:blue; text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed  	{color:purple;
text-decoration:underline;} span.EmailStyle17  	{ font-family:Arial;
color:windowtext;}  _filtered { margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1  	{} -->             Hello,

         Can someone remind me how to find what user dialed 911  in the
system? If I recall this information is on the Publisher somewhere in
SQL. 

     I am running CCM 4.1(3)es91.

     Thanks!

     Jason

     Jason T. Burwell

     Infrastructure/Telecommunications

     First Charter Bank

     10200 David    Taylor Drive

     Charlotte,  NC 28262

     ph-704-688-4664

     fax-704-688-4901

     www.firstcharter.com

    _______________________________________________

cisco-voip mailing list

cisco-voip at puck.nether.net

https://puck.nether.net/mailman/listinfo/cisco-voip

________________________________________________________________________
____________
Sucker-punch spam with award-winning protection. 
Try the free Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/features_spam.html

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

--------------------------------------------------------
This e-mail message and any attached files are confidential and are
intended solely for the use of the addressee(s) named above. This
communication may contain material protected by attorney-client, work
product, or other privileges. If you are not the intended recipient or
person responsible for delivering this confidential communication to the
intended recipient, you have received this communication in error, and
any review, use, dissemination, forwarding, printing, copying, or other
distribution of this e-mail message and any attached files is strictly
prohibited. Dickstein Shapiro reserves the right to monitor any
communication that is created, received, or sent on its network.  If you
have received this confidential communication in error, please notify
the sender immediately by reply e-mail message and permanently delete
the original message. 

To reply to our email administrator directly, send an email to
postmaster at dicksteinshapiro.com

Dickstein Shapiro LLP
http://www.DicksteinShapiro.com
========================================================================
======

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
This email is from 2e2 UK Limited.  The contents of this email and
any attachments are confidential to the intended recipient. They may
not be disclosed to or used by or copied in any way by anyone other
than the intended recipient. If this email is received in error,
please contact 2e2 UK Limited on +44 (0) 1635 520111 quoting the name
of the sender and the email address to which it has been sent and
then delete it.

Please note that neither 2e2 UK Limited nor the sender accepts any
responsibility for viruses and it is your responsibility to scan or
otherwise check this email and any attachments. 

2e2 UK Limited is a company registered in England with registered
number 4090390 whose registered office business is: The Mansion House
Benham Valence, Speen, Near Newbury, Berks RG20 8LU.  For further
information, please refer to www.2e2.com.

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

--------------------------------------------------------------------
mail2web.com – What can On Demand Business Solutions do for you?
http://link.mail2web.com/Business/SharePoint