[cisco-voip] Automatic Email/SMS Notification for Emergency Calls Solution

[Johan Bloemhard]

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/20060908/f9e5b518/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: emergency_call_checker.php
Type: application/octet-stream
Size: 6050 bytes
Desc: emergency_call_checker.php
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20060908/f9e5b518/attachment.obj