<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Tahoma;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:220947327;
mso-list-type:hybrid;
mso-list-template-ids:2056579946 -1732985958 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Tahoma;
mso-fareast-font-family:"Times New Roman";}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'>The parts to setting it up are as follows:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><font
size=1 color=blue face=Tahoma><span style='font-size:8.0pt;font-family:Tahoma;
color:blue'><span style='mso-list:Ignore'>-<font size=1 face="Times New Roman"><span
style='font:7.0pt "Times New Roman"'>
</span></font></span></span></font><![endif]><font size=1 color=blue
face=Tahoma><span style='font-size:8.0pt;font-family:Tahoma;color:blue'>Install
PHP with MS SQL (mssql) support<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><font
size=1 color=blue face=Tahoma><span style='font-size:8.0pt;font-family:Tahoma;
color:blue'><span style='mso-list:Ignore'>-<font size=1 face="Times New Roman"><span
style='font:7.0pt "Times New Roman"'>
</span></font></span></span></font><![endif]><font size=1 color=blue
face=Tahoma><span style='font-size:8.0pt;font-family:Tahoma;color:blue'>Change
over the SQL server to SA authentication “mixed”<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><font
size=1 color=blue face=Tahoma><span style='font-size:8.0pt;font-family:Tahoma;
color:blue'><span style='mso-list:Ignore'>-<font size=1 face="Times New Roman"><span
style='font:7.0pt "Times New Roman"'>
</span></font></span></span></font><![endif]><font size=1 color=blue
face=Tahoma><span style='font-size:8.0pt;font-family:Tahoma;color:blue'>Give
user rights to query the CCM tables<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'>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:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'>“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.”<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'>The time on the message is nice because
most of the time you can tell if it was a mistake call or not.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'>If you’re interested in more
details, contact me and I’ll assist you in any way possible.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Tahoma><span style='font-size:
8.0pt;font-family:Tahoma;color:blue'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=1 color=blue face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;color:blue'>Johan Bloemhard <br>
Senior Information Technology Specialist <br>
___________________________________ <br>
<st1:place w:st="on"><st1:PlaceName w:st="on"><strong><b><font face=Verdana><span
style='font-family:Verdana'>Silver</span></font></b></strong></st1:PlaceName><strong><b><font
face=Verdana><span style='font-family:Verdana'> <st1:PlaceType w:st="on">Falls</st1:PlaceType>
<st1:PlaceType w:st="on">School District</st1:PlaceType></span></font></b></strong></st1:place><strong><b><font
face=Verdana><span style='font-family:Verdana'> 4J</span></font></b></strong> <br>
<st1:address w:st="on"><st1:Street w:st="on">802 Schlador Street</st1:Street> <br>
<st1:City w:st="on">Silverton</st1:City>, <st1:State w:st="on">OR</st1:State> <st1:PostalCode
w:st="on">97381</st1:PostalCode></st1:address> </span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Miller, Steve<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, February 13, 2007
7:55 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Voll, Scott; Jason Burwell;
cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [cisco-voip] Who
called 911</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>That would be incredible. More
details about how to implement this would be great!</span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'><!-- Converted from text/rtf format -->Steve Miller<br>
Telecom Engineer<br>
Dickstein Shapiro LLP<br>
<st1:Street w:st="on"><st1:address w:st="on">1825 Eye Street NW</st1:address></st1:Street>
| <st1:place w:st="on"><st1:City w:st="on">Washington</st1:City>, <st1:State
w:st="on">DC</st1:State> <st1:PostalCode w:st="on">20006</st1:PostalCode></st1:place><br>
Tel (202) 420-3370 Fax (202)-330-5607<br>
</span></font><a href="mailto:millers@dicksteinshapiro.com"><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>millers@dicksteinshapiro.com</span></font></a><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Voll, Scott<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, February 13, 2007
10:52 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Jason Burwell;
cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [cisco-voip] Who
called 911</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><a href="https://cm/art">https://cm/art</a>
and search based on route pattern is the easiest for me.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Scott<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Jason Burwell<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, February 12, 2007
1:20 PM<br>
<b><span style='font-weight:bold'>To:</span></b> cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [cisco-voip] Who called
911</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> 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. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am running CCM 4.1(3)es91.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Jason<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Jason T. Burwell</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Infrastructure/Telecommunications</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>First Charter Bank</span></font><o:p></o:p></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>10200 David
Taylor Drive</span></font></st1:address></st1:Street><o:p></o:p></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>Charlotte</span></font></st1:City><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>, <st1:State
w:st="on">NC</st1:State> <st1:PostalCode w:st="on">28262</st1:PostalCode></span></font></st1:place><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ph-704-688-4664</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>fax-704-688-4901</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>www.firstcharter.com</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>--------------------------------------------------------<br>
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. <br>
<br>
To reply to our email administrator directly, send an email to postmaster@dicksteinshapiro.com<br>
<br>
Dickstein Shapiro LLP<br>
http://www.DicksteinShapiro.com<br>
==============================================================================<o:p></o:p></span></font></p>
</div>
</body>
</html>