<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>There is a service parameter to enable/disable 0
lenght CDRs. I keep them in for troubleshooting.</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=BRiley@jackhenry.com href="mailto:BRiley@jackhenry.com">Bill Riley
III</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=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> Wednesday, March 29, 2006 5:49
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [cisco-voip] CDR
report</DIV>
<DIV><BR></DIV>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: <A
href="mailto:cisco-voip@puck.nether.net">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
href="mailto:BRiley@jackhenry.com">BRiley@jackhenry.com</A>><BR>Subject:
[cisco-voip] CDR report<BR>To: <<A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A>><BR>Message-ID:<BR><<A
href="mailto:13591CB4B2359F4D96E2606DD6B840A0024B7BBD@smoxchg.jhacorp.com">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
href="mailto:Jon_Pritchard@adp.com">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
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR></BLOCKQUOTE></BODY></HTML>