<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2800.1528" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>This could be done by setting up a Unity
CallHandler. It means that your emergency calls depend on Unity being up, but
it's an option.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The route patterns already have a blocked route
annunciator, it shouldn't be too hard to program an allowed route annunciator.
;)</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ealeatherman@gmail.com href="mailto:ealeatherman@gmail.com">Ed
Leatherman</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=Jon_Pritchard@adp.com
href="mailto:Jon_Pritchard@adp.com">Pritchard, Jon</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=Scott.Voll@wesd.org
href="mailto:Scott.Voll@wesd.org">Voll, Scott</A> ; <A title=lelio@uoguelph.ca
href="mailto:lelio@uoguelph.ca">Lelio Fulgenzi</A> ; <A
title=BRiley@jackhenry.com href="mailto:BRiley@jackhenry.com">Bill Riley
III</A> ; <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, March 30, 2006 7:57
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [cisco-voip] CDR
report</DIV>
<DIV><BR></DIV>We route 911 and 9.911 also. We include that as part of
training when we install IP sets, and I also remind all the contact folks once
a month in our maintenance notice. We also stress that even if they dont mean
to call it, to stay on the line and let the dispatcher know they arent having
an emergency. We still get some hang ups to 911 though, i'm not sure what else
to do about it - management doesnt want us changing the dial patterns.
<BR><BR>The message about connecting to emergency services is a good
idea.<BR><BR>
<DIV><SPAN class=gmail_quote>On 3/29/06, <B class=gmail_sendername>Pritchard,
Jon</B> <<A href="mailto:Jon_Pritchard@adp.com ">Jon_Pritchard@adp.com
</A>> wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV style="DIRECTION: ltr">
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">We limit to 9.911
for many of our customers and in states where it's required (like
California) we label th phones.</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Some customers opt
for an outdial code of 8 instead of 9. That helps a
lot.</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Jon</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=3>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Voll,
Scott [mailto:<A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Scott.Voll@wesd.org" target=_blank>Scott.Voll@wesd.org</A>]
<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, March 29,
2006 3:31 PM</SPAN></FONT></P></DIV><FONT face=Tahoma size=2></FONT>
<DIV style="DIRECTION: ltr"><SPAN class=q><FONT face=Tahoma
size=2><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Lelio Fulgenzi;
Bill Riley III; Pritchard, Jon<BR><B><SPAN
style="FONT-WEIGHT: bold">Cc:</SPAN></B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A><BR></FONT></SPAN></DIV>
<DIV style="DIRECTION: ltr"><SPAN class=e id=q_10a490fd79cbf01a_2><FONT
face=Tahoma size=2><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
RE: [cisco-voip] CDR report</FONT></SPAN></DIV>
<DIV style="DIRECTION: ltr">
<P></P></DIV></DIV>
<DIV style="DIRECTION: ltr"><SPAN class=e id=q_10a490fd79cbf01a_4>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I keep them in for
slapping the end users who keep calling 911 then hanging
up.</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Speaking of that,
what does everyone else do? I route both 9.911 and 911. But I'm
seeing a lot of 911 calls. Have people moved to dialing 8. rather then
9. or are people not routing 911 and only 9.911.</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Scott</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip-bounces@puck.nether.net"
target=_blank>cisco-voip-bounces@puck.nether.net</A> [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip-bounces@puck.nether.net" target=_blank>
cisco-voip-bounces@puck.nether.net</A>] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Lelio Fulgenzi<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, March 29, 2006 3:20
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Bill Riley III;
Pritchard, Jon<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A><BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [cisco-voip] CDR
report</SPAN></FONT></P></DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">There is a service parameter to
enable/disable 0 lenght CDRs. I keep them in for
troubleshooting.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; MARGIN: 5pt 0in 5pt 3.75pt; BORDER-LEFT: 1.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: medium none">
<DIV>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----- Original Message -----
</SPAN></FONT></P></DIV>
<DIV>
<P
style="BACKGROUND: rgb(228,228,228) 0% 50%; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial"><B><FONT
face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">From:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <A
title=BRiley@jackhenry.com
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:BRiley@jackhenry.com" target=_blank>Bill Riley III</A>
</SPAN></FONT></P></DIV>
<DIV>
<P><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">To:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <A
title=Jon_Pritchard@adp.com
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Jon_Pritchard@adp.com" target=_blank>Pritchard, Jon</A>
</SPAN></FONT></P></DIV>
<DIV>
<P><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Cc:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <A
title=cisco-voip@puck.nether.net
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A> </SPAN></FONT></P></DIV>
<DIV>
<P><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sent:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
Wednesday, March 29, 2006 5:49 PM</SPAN></FONT></P></DIV>
<DIV>
<P><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Subject:</SPAN></FONT></B><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> Re:
[cisco-voip] CDR report</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<P style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">I used a SQL query and then converted the time in
Excel. I took out the calls that were 0 and less but isn't there a
way to stop them from being logged in the first place.
<BR><BR><BR>SELECT dateTimeOrigination,
callingPartyNumber, finalCalledPartyNumber, originalCalledPartyNumber,
duration<BR>FROM
CallDetailRecord<BR>WHERE (callingPartyNumber LIKE
'13%') AND (duration > '0') AND (dateTimeOrigination < '1143615600')
AND (dateTimeOrigination > '1138777200')<BR><BR>-----Original
Message-----<BR>From: Pritchard, Jon [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Jon_Pritchard@adp.com"
target=_blank>Jon_Pritchard@adp.com</A>] <BR>Sent: Wednesday, March 29,
2006 4:45 PM<BR>To: Bill Riley III<BR>Cc: <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A><BR>Subject: RE: [cisco-voip]
CDR report<BR><BR>No dice. We wrote our own. For a third
party take a look at Syn-Apps call accounting. They do good
stuff.<BR><BR>Jon<BR><BR>-----------------------------------------------<BR><BR>Date:
Wed, 29 Mar 2006 15:49:49 -0600<BR>From: "Bill Riley III" <<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:BRiley@jackhenry.com"
target=_blank>BRiley@jackhenry.com</A>><BR>Subject: [cisco-voip] CDR
report<BR>To: <<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A>><BR>Message-ID:<BR><<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:13591CB4B2359F4D96E2606DD6B840A0024B7BBD@smoxchg.jhacorp.com"
target=_blank>13591CB4B2359F4D96E2606DD6B840A0024B7BBD@smoxchg.jhacorp.com</A>>
<BR>Content-Type: text/plain; charset="us-ascii"<BR><BR>I have a customer
that wants to get all of the calls a certain group of extensions made for
the last 60 days. I am using the built in CDR analysis and reporting and
when I go to CDR>search>by User/Extension and put in the extensions
I want to search by, 13XX, and the date ranges, it only gives me the first
100 rows. How do I increase the output so it will not be truncated?
<BR> <BR><BR>Thanks,<BR><BR>Bill
Riley<BR><BR><BR>
All Content of this document is ADP Confidential 2006<BR>Jon Pritchard -
Sr. Network Engineer<BR>Network Solutions Group<BR>ADP Dealer Services,
2525 SW First Avenue, Portland, OR 97201<BR>phone: (503) 205-4428, fax:
(503) 402-3277<BR>email: <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Jon_Pritchard@adp.com"
target=_blank>Jon_Pritchard@adp.com</A><BR><BR><BR><BR><BR><BR><BR>This
message and any attachments are intended only for the use of the addressee
and may contain information that is privileged and confidential. If the
reader of the message is not the intended recipient or an authorized
representative of the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
e-mail and delete the message and any attachments from your
system.<BR><BR><BR><BR>NOTICE: This electronic mail message and any files
transmitted with it are intended exclusively for the individual or entity
to which it is addressed. The message, together with any attachment, may
contain confidential and/or privileged information. Any unauthorized
review, use, printing, saving, copying, disclosure or distribution is
strictly prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all
copies.<BR><BR><BR><BR><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A></SPAN></FONT></P></BLOCKQUOTE></SPAN></DIV>
<DIV style="DIRECTION: ltr"></DIV>
<DIV>
<P></P>
<HR>
</DIV>
<DIV style="DIRECTION: ltr"><SPAN class=q>This message and any attachments
are intended only for the use of the addressee and may contain information
that is privileged and confidential. If the reader of the message is not the
intended recipient or an authorized representative of the intended
recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail and delete
the message and any attachments from your system. </SPAN></DIV>
<DIV style="DIRECTION: ltr">
<P></P></DIV></DIV><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Ed Leatherman<BR>IP Telephony Coordinator<BR>West
Virginia University<BR>Telecommunications and Network Operations
</BLOCKQUOTE></BODY></HTML>