<br><font size=2 face="sans-serif">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 size=2 face="sans-serif">Craig<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Lelio Fulgenzi" <lelio@uoguelph.ca></b></font>
<br><font size=1 face="sans-serif">Sent by: cisco-voip-bounces@puck.nether.net</font>
<p><font size=1 face="sans-serif">03/29/2006 06:30 PM</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: "Voll, Scott" <Scott.Voll@wesd.org>, "Bill Riley III" <BRiley@jackhenry.com>, "Pritchard, Jon" <Jon_Pritchard@adp.com></font>
<br><font size=1 face="sans-serif"> cc: cisco-voip@puck.nether.net</font>
<br><font size=1 face="sans-serif"> Subject: Re: [cisco-voip] CDR report</font></table>
<br>
<br>
<br><font size=2 face="Arial">we route both 911 and 9.911.</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">i think the best thing is to educate people. have announcements made, etc. something you do once a month or whatever.</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">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 size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">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 size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">----- Original Message ----- </font>
<br><font size=3 face="Times New Roman"><b>From:</b> </font><a href=mailto:Scott.Voll@wesd.org><font size=3 color=blue face="Times New Roman"><u>Voll, Scott</u></font></a><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman"><b>To:</b> </font><a href=mailto:lelio@uoguelph.ca><font size=3 color=blue face="Times New Roman"><u>Lelio Fulgenzi</u></font></a><font size=3 face="Times New Roman"> ; </font><a href=mailto:BRiley@jackhenry.com><font size=3 color=blue face="Times New Roman"><u>Bill Riley III</u></font></a><font size=3 face="Times New Roman"> ; </font><a href=mailto:Jon_Pritchard@adp.com><font size=3 color=blue face="Times New Roman"><u>Pritchard, Jon</u></font></a><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman"><b>Cc:</b> </font><a href="mailto:cisco-voip@puck.nether.net"><font size=3 color=blue face="Times New Roman"><u>cisco-voip@puck.nether.net</u></font></a><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman"><b>Sent:</b> Wednesday, March 29, 2006 6:31 PM</font>
<br><font size=3 face="Times New Roman"><b>Subject:</b> RE: [cisco-voip] CDR report</font>
<br>
<br><font size=2 color=#000080 face="Arial">I keep them in for slapping the end users who keep calling 911 then hanging up.</font>
<br><font size=2 color=#000080 face="Arial"> </font>
<br><font size=2 color=#000080 face="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.</font>
<br><font size=2 color=#000080 face="Arial"> </font>
<br><font size=2 color=#000080 face="Arial">Scott</font>
<br><font size=2 color=#000080 face="Arial"> </font>
<br><font size=2 color=#000080 face="Arial"> </font>
<br><font size=2 color=#000080 face="Arial"> </font>
<div align=center>
<br>
<hr></div>
<br><font size=2 face="Tahoma"><b>From:</b> </font><a href="mailto:cisco-voip-bounces@puck.nether.net"><font size=2 color=blue face="Tahoma"><u>cisco-voip-bounces@puck.nether.net</u></font></a><font size=2 face="Tahoma"> [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 size=2 color=blue face="Tahoma"><u>cisco-voip@puck.nether.net</u></font></a><font size=2 face="Tahoma"><b><br>
Subject:</b> Re: [cisco-voip] CDR report</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">There is a service parameter to enable/disable 0 lenght CDRs. I keep them in for troubleshooting.</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">----- Original Message ----- </font>
<br><font size=2 face="Arial"><b>From:</b> </font><a href=mailto:BRiley@jackhenry.com><font size=2 color=blue face="Arial"><u>Bill Riley III</u></font></a><font size=2 face="Arial"> </font>
<br><font size=2 face="Arial"><b>To:</b> </font><a href=mailto:Jon_Pritchard@adp.com><font size=2 color=blue face="Arial"><u>Pritchard, Jon</u></font></a><font size=2 face="Arial"> </font>
<br><font size=2 face="Arial"><b>Cc:</b> </font><a href="mailto:cisco-voip@puck.nether.net"><font size=2 color=blue face="Arial"><u>cisco-voip@puck.nether.net</u></font></a><font size=2 face="Arial"> </font>
<br><font size=2 face="Arial"><b>Sent:</b> Wednesday, March 29, 2006 5:49 PM</font>
<br><font size=2 face="Arial"><b>Subject:</b> Re: [cisco-voip] CDR report</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">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 size=3 color=blue face="Times New Roman"><u>cisco-voip@puck.nether.net</u></font></a><font size=3 face="Times New Roman"><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 size=3 color=blue face="Times New Roman"><u>BRiley@jackhenry.com</u></font></a><font size=3 face="Times New Roman">><br>
Subject: [cisco-voip] CDR report<br>
To: <</font><a href="mailto:cisco-voip@puck.nether.net"><font size=3 color=blue face="Times New Roman"><u>cisco-voip@puck.nether.net</u></font></a><font size=3 face="Times New Roman">></font>
<br><font size=3 face="Times New Roman">Message-ID:<br>
<</font><a href=mailto:13591CB4B2359F4D96E2606DD6B840A0024B7BBD@smoxchg.jhacorp.com><font size=3 color=blue face="Times New Roman"><u>13591CB4B2359F4D96E2606DD6B840A0024B7BBD@smoxchg.jhacorp.com</u></font></a><font size=3 face="Times New Roman">><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 size=3 color=blue face="Times New Roman"><u>Jon_Pritchard@adp.com</u></font></a><font size=3 face="Times New Roman"><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 size=3 color=blue face="Times New Roman"><u><br>
</u></font><a href="mailto:cisco-voip@puck.nether.net"><font size=3 color=blue face="Times New Roman"><u>cisco-voip@puck.nether.net</u></font></a><font size=3 color=blue face="Times New Roman"><u><br>
</u></font><a href="https://puck.nether.net/mailman/listinfo/cisco-voip"><font size=3 color=blue face="Times New Roman"><u>https://puck.nether.net/mailman/listinfo/cisco-voip</u></font></a><font size=2 face="Courier New">_______________________________________________<br>
cisco-voip mailing list<br>
cisco-voip@puck.nether.net<br>
https://puck.nether.net/mailman/listinfo/cisco-voip<br>
</font>
<br>
<br>