[cisco-voip] 911 dialing notification

[Gary L. Pate]

This was an old post. Doesn't correct the 911 dialing problem, but at least
it lets you know who did it and maybe user training will help!

 

  _____  

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Johan Bloemhard
Sent: Friday, September 08, 2006 6:35 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Automatic Email/SMS Notification for Emergency
CallsSolution

 

Since so many of you have assisted me, I would like to share a little script
that I made that checks for someone dialing an emergency number (eg 911) and
then have the system email a distribution list (emails/sms) of managers
which should be notified for emergency purposes.

 

The script itself isn't a great mystery but hopefully will save some time
for you.

 

You can set it up to poll on the interval you wish.  Once it finds a call
record, it adds the pkid to a log database so it doesn't poll it again in
the future.  Because it's not intensive on the server/DB, I set it up to
poll every minute.  

 

You can pull information such as the calling party id, line label, internal
calling id, CSS, and more. 

 

This does require the basic knowledge of web servers, PHP, SQL and requires
users to be setup on the corresponding databases.  For myself, I use
CDRReporter and changed CDRReporter to db_owner on CCM0300 so that it has
select privileges.  The PHP server needs to be compiled for mssql extension
support.

 

This is a sample email that I have sent to an administrator distribution
list:

Extension 6343 with label (Mr. Smith x6343) and internal caller id (John
Smith) at the High School called 911 at 08/22/06 05:28:00 PM for 0.3 min.
This extension is registered to smith_john.

 

Administrators love it and hopefully some of you will find it helpful as
well.

 

Feel free to contact me if you have any questions.

 

 

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

 


  _____  

Disclaimer: This message may be legally privileged and/or is intended only
for the use of the addressee(s). The content and views expressed in this
email may represent the views of the sender and not those of Silver Falls
School District. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070330/8d49a044/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: emergency_call_checker.php
Type: application/octet-stream
Size: 5899 bytes
Desc: not available
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20070330/8d49a044/attachment.obj 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ATT00216.txt
Url: https://puck.nether.net/pipermail/cisco-voip/attachments/20070330/8d49a044/attachment.txt