<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=906350614-30032006><FONT face=Arial
color=#0000ff size=2>Many places move regular dialing to 8, like Scott had
mentioned, and leave 911 and 9.911 as the only things that dial by
9.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906350614-30032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906350614-30032006><FONT face=Arial
color=#0000ff size=2>This has worked successfully in numerous
locations.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906350614-30032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906350614-30032006><FONT face=Arial
color=#0000ff size=2>Only real catch is user re-training. It does take
time for folks to get used to dialing 8.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Craig M
Staffin<BR><B>Sent:</B> Thursday, March 30, 2006 8:05 AM<BR><B>To:</B> Lelio
Fulgenzi<BR><B>Cc:</B> cisco-voip-bounces@puck.nether.net; Bill Riley III;
Pritchard, Jon; cisco-voip@puck.nether.net; Voll, Scott<BR><B>Subject:</B> Re:
[cisco-voip] CDR report<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Before you make any changes to 911
dialing check with your local laws. I know in the state of wisconsin we
need to route both 9911 and 911. The only way around this is if there is
a sticker on every phone telling the people otherwise</FONT> <BR><BR><FONT
face=sans-serif size=2>Craig<BR></FONT><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<TD><FONT face=sans-serif size=1><B>"Lelio Fulgenzi"
<lelio@uoguelph.ca></B></FONT> <BR><FONT face=sans-serif
size=1>Sent by: cisco-voip-bounces@puck.nether.net</FONT>
<P><FONT face=sans-serif size=1>03/29/2006 06:30 PM</FONT> <BR></P>
<TD><FONT face=Arial size=1> </FONT><BR><FONT
face=sans-serif size=1> To:
"Voll, Scott" <Scott.Voll@wesd.org>, "Bill Riley III"
<BRiley@jackhenry.com>, "Pritchard, Jon"
<Jon_Pritchard@adp.com></FONT> <BR><FONT face=sans-serif
size=1> cc:
cisco-voip@puck.nether.net</FONT> <BR><FONT face=sans-serif
size=1> Subject:
Re: [cisco-voip] CDR report</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT
face=Arial size=2>we route both 911 and 9.911.</FONT> <BR><FONT
face="Times New Roman" size=3> </FONT> <BR><FONT face=Arial size=2>i
think the best thing is to educate people. have announcements made, etc.
something you do once a month or whatever.</FONT> <BR><FONT
face="Times New Roman" size=3> </FONT> <BR><FONT face=Arial size=2>you
can consider to not mark 911 as urgent so it waits the interdigit timeout. but
some (including me) may not like the idea. i'm guessing a lot can happen in 15
seconds.</FONT> <BR><FONT face="Times New Roman" size=3> </FONT>
<BR><FONT face=Arial size=2>it would be great if there could be a wave file
played just before a call is routed, so it says something like, please wait
while your call is routed to the city emergency services <2 second
pause> then route. this would give them enough time to hang up and not
cause any grief.</FONT> <BR><FONT face="Times New Roman" size=3> </FONT>
<BR><FONT face="Times New Roman" size=3> </FONT> <BR><FONT
face="Times New Roman" size=3>----- Original Message ----- </FONT><BR><FONT
face="Times New Roman" size=3><B>From:</B> </FONT><A
href="mailto:Scott.Voll@wesd.org"><FONT face="Times New Roman" color=blue
size=3><U>Voll, Scott</U></FONT></A><FONT face="Times New Roman" size=3>
</FONT><BR><FONT face="Times New Roman" size=3><B>To:</B> </FONT><A
href="mailto:lelio@uoguelph.ca"><FONT face="Times New Roman" color=blue
size=3><U>Lelio Fulgenzi</U></FONT></A><FONT face="Times New Roman" size=3> ;
</FONT><A href="mailto:BRiley@jackhenry.com"><FONT face="Times New Roman"
color=blue size=3><U>Bill Riley III</U></FONT></A><FONT face="Times New Roman"
size=3> ; </FONT><A href="mailto:Jon_Pritchard@adp.com"><FONT
face="Times New Roman" color=blue size=3><U>Pritchard, Jon</U></FONT></A><FONT
face="Times New Roman" size=3> </FONT><BR><FONT face="Times New Roman"
size=3><B>Cc:</B> </FONT><A href="mailto:cisco-voip@puck.nether.net"><FONT
face="Times New Roman" color=blue
size=3><U>cisco-voip@puck.nether.net</U></FONT></A><FONT
face="Times New Roman" size=3> </FONT><BR><FONT face="Times New Roman"
size=3><B>Sent:</B> Wednesday, March 29, 2006 6:31 PM</FONT> <BR><FONT
face="Times New Roman" size=3><B>Subject:</B> RE: [cisco-voip] CDR
report</FONT> <BR><BR><FONT face=Arial color=#000080 size=2>I keep them in for
slapping the end users who keep calling 911 then hanging up.</FONT> <BR><FONT
face=Arial color=#000080 size=2> </FONT> <BR><FONT face=Arial
color=#000080 size=2>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.</FONT> <BR><FONT face=Arial color=#000080 size=2> </FONT>
<BR><FONT face=Arial color=#000080 size=2>Scott</FONT> <BR><FONT face=Arial
color=#000080 size=2> </FONT> <BR><FONT face=Arial color=#000080
size=2> </FONT> <BR><FONT face=Arial color=#000080 size=2> </FONT>
<DIV align=center><BR>
<HR>
</DIV><BR><FONT face=Tahoma size=2><B>From:</B> </FONT><A
href="mailto:cisco-voip-bounces@puck.nether.net"><FONT face=Tahoma color=blue
size=2><U>cisco-voip-bounces@puck.nether.net</U></FONT></A><FONT face=Tahoma
size=2> [mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Lelio
Fulgenzi<B><BR>Sent:</B> Wednesday, March 29, 2006 3:20 PM<B><BR>To:</B> Bill
Riley III; Pritchard, Jon<B><BR>Cc:</B> </FONT><A
href="mailto:cisco-voip@puck.nether.net"><FONT face=Tahoma color=blue
size=2><U>cisco-voip@puck.nether.net</U></FONT></A><FONT face=Tahoma
size=2><B><BR>Subject:</B> Re: [cisco-voip] CDR report</FONT> <BR><FONT
face="Times New Roman" size=3> </FONT> <BR><FONT face=Arial size=2>There
is a service parameter to enable/disable 0 lenght CDRs. I keep them in for
troubleshooting.</FONT> <BR><FONT face="Times New Roman" size=3> </FONT>
<BR><FONT face=Arial size=2>----- Original Message ----- </FONT><BR><FONT
face=Arial size=2><B>From:</B> </FONT><A
href="mailto:BRiley@jackhenry.com"><FONT face=Arial color=blue size=2><U>Bill
Riley III</U></FONT></A><FONT face=Arial size=2> </FONT><BR><FONT face=Arial
size=2><B>To:</B> </FONT><A href="mailto:Jon_Pritchard@adp.com"><FONT
face=Arial color=blue size=2><U>Pritchard, Jon</U></FONT></A><FONT face=Arial
size=2> </FONT><BR><FONT face=Arial size=2><B>Cc:</B> </FONT><A
href="mailto:cisco-voip@puck.nether.net"><FONT face=Arial color=blue
size=2><U>cisco-voip@puck.nether.net</U></FONT></A><FONT face=Arial size=2>
</FONT><BR><FONT face=Arial size=2><B>Sent:</B> Wednesday, March 29, 2006 5:49
PM</FONT> <BR><FONT face=Arial size=2><B>Subject:</B> Re: [cisco-voip] CDR
report</FONT> <BR><FONT face="Times New Roman" size=3> </FONT> <BR><FONT
face="Times New Roman" size=3>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:Jon_Pritchard@adp.com] <BR>Sent:
Wednesday, March 29, 2006 4:45 PM<BR>To: Bill Riley III<BR>Cc: </FONT><A
href="mailto:cisco-voip@puck.nether.net"><FONT face="Times New Roman"
color=blue size=3><U>cisco-voip@puck.nether.net</U></FONT></A><FONT
face="Times New Roman" size=3><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" <</FONT><A
href="mailto:BRiley@jackhenry.com"><FONT face="Times New Roman" color=blue
size=3><U>BRiley@jackhenry.com</U></FONT></A><FONT face="Times New Roman"
size=3>><BR>Subject: [cisco-voip] CDR report<BR>To: <</FONT><A
href="mailto:cisco-voip@puck.nether.net"><FONT face="Times New Roman"
color=blue size=3><U>cisco-voip@puck.nether.net</U></FONT></A><FONT
face="Times New Roman" size=3>></FONT> <BR><FONT face="Times New Roman"
size=3>Message-ID:<BR><</FONT><A
href="mailto:13591CB4B2359F4D96E2606DD6B840A0024B7BBD@smoxchg.jhacorp.com"><FONT
face="Times New Roman" color=blue
size=3><U>13591CB4B2359F4D96E2606DD6B840A0024B7BBD@smoxchg.jhacorp.com</U></FONT></A><FONT
face="Times New Roman" size=3>><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: </FONT><A
href="mailto:Jon_Pritchard@adp.com"><FONT face="Times New Roman" color=blue
size=3><U>Jon_Pritchard@adp.com</U></FONT></A><FONT face="Times New Roman"
size=3><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</FONT><FONT face="Times New Roman" color=blue
size=3><U><BR></U></FONT><A href="mailto:cisco-voip@puck.nether.net"><FONT
face="Times New Roman" color=blue
size=3><U>cisco-voip@puck.nether.net</U></FONT></A><FONT
face="Times New Roman" color=blue size=3><U><BR></U></FONT><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip"><FONT
face="Times New Roman" color=blue
size=3><U>https://puck.nether.net/mailman/listinfo/cisco-voip</U></FONT></A><FONT
face="Courier New"
size=2>_______________________________________________<BR>cisco-voip mailing
list<BR>cisco-voip@puck.nether.net<BR>https://puck.nether.net/mailman/listinfo/cisco-voip<BR></FONT><BR><BR></BLOCKQUOTE></BODY></HTML>