[cisco-voip] Who called 911

[Johan Bloemhard]

I implemented a PHP solution that polls the SQL server every minute.
Because of the query, the poll is extremely minimal. It is a little
trickier to set up but once it's setup, it works very nice.

 

The parts to setting it up are as follows:

-          Install PHP with MS SQL (mssql) support

-          Change over the SQL server to SA authentication "mixed"

-          Give user rights to query the CCM tables

 

Here's the message that my system sends out to administrator cell phones
and emails.  You can customize it in any way you see fit:

"Extension 6236 at High School called 911 at 12/6/06 01:19:27 PM for 0.2
min. This extension is registered to doe_john."

 

The time on the message is nice because most of the time you can tell if
it was a mistake call or not.

 

If you're interested in more details, contact me and I'll assist you in
any way possible.

 

 

Johan Bloemhard 
Senior Information Technology Specialist 
___________________________________ 
Silver Falls School District 4J 
802 Schlador Street 
Silverton, OR 97381 

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Miller, Steve
Sent: Tuesday, February 13, 2007 7:55 AM
To: Voll, Scott; Jason Burwell; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Who called 911

 

That would be incredible.  More details about how to implement this
would be great!

 

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 Voll, Scott
Sent: Tuesday, February 13, 2007 10:52 AM
To: Jason Burwell; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Who called 911

https://cm/art and search based on route pattern is the easiest for me.

 

But if Johan is on the list.... He created a 911 PHP script that will
actually email you the number calling 911, the user associated to the
phone and time of call and duration of call.  Works very slick.

 

Scott

 

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Jason Burwell
Sent: Monday, February 12, 2007 1:20 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Who called 911

 

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

 

--------------------------------------------------------
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/20070213/70fdb439/attachment.html