[cisco-voip] Who called 911 GOOD ADVICE FROM AN EXPERT - PLEASE READ!

[Miller, Steve]

The information that I was seeking yesterday yielded an amazing amount
of suggestions, all of which were helpful in many different ways for
different scenarios, but this one definitely proved to be very helpful.
It was counter-intuitive to me that "911" should be entered as an
"extension", but that's how it works.  See below from a truly great
Cisco telephone engineer:
 
The most reliable way to search for specific calls is to use the CAR
CDR>Search by>User/Extension report.  In this case, you enter 911 in the
Extension field, click Add Extension, set the from and to date/time, and
click OK. 

This will generate a list of CDR records. Click the "View" link on the
right to bring up a window with the date and time of the call, duration,
and other pertinent information.

Use the CAR User Reports>TopN report to find the top N numbers by calls,
or by duration of calls. For outgoing calls, uncheck the Internal and
Incoming categories (and possibly On Net), select how many top numbers
you want to see in "No of Records", select the date range, and run the
report.

You can do lots of interesting things with the SQL Query Analyzer, but I
don't recommend using it unless you know SQL fairly well. You can quite
easily destroy part of your CallManager database with the wrong command.
Instructions on how to use the SQL Query Analyzer are beyond the scope
of maintenance services.

 

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 <mailto:millers at dicksteinshapiro.com>  

 

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Ed Leatherman
Sent: Tuesday, February 13, 2007 4:26 PM
To: Biffle, Gerrad
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Who called 911


My 2cts..

From what i've found with CER, it can notify via email or it can call
specific numbers. The problem I have with the callout feature is that as
far as I can tell it will only specify the phone number that called
911.. which by itself in a large campus doesnt do our public safety much
good. They still have to go out to the webpage to see the location
information (which CER does generally do a good job of keeping track). 

Have the info available on a phone screen is a REALLY good idea.


On 2/13/07, Biffle, Gerrad < Gerrad.Biffle at greensboro-nc.gov
<mailto:Gerrad.Biffle at greensboro-nc.gov> > wrote: 

	I want to say Emergency Responder has the capability to notify
on-site 
	personnel (i.e. security guard) if a 911 call is placed.  Or ...
were
	you trying to avoid the Emergency Responder route?
	
	



-- 
Ed Leatherman
Senior Voice Engineer
West Virginia University
Telecommunications and Network Operations 

--------------------------------------------------------
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
==============================================================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070214/f1ad36ad/attachment.html