| Johan Bloemhard 2006-09-08, 7:11 pm |
| 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.
|