[cisco-voip] CDR report

[Lelio Fulgenzi]

There is a service parameter to enable/disable 0 lenght CDRs. I keep them in for troubleshooting.

  ----- Original Message ----- 
  From: Bill Riley III 
  To: Pritchard, Jon 
  Cc: cisco-voip at puck.nether.net 
  Sent: Wednesday, March 29, 2006 5:49 PM
  Subject: Re: [cisco-voip] CDR report


  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. 


  SELECT     dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber, originalCalledPartyNumber, duration
  FROM         CallDetailRecord
  WHERE     (callingPartyNumber LIKE '13%') AND (duration > '0') AND (dateTimeOrigination < '1143615600') AND (dateTimeOrigination > '1138777200')

  -----Original Message-----
  From: Pritchard, Jon [mailto:Jon_Pritchard at adp.com] 
  Sent: Wednesday, March 29, 2006 4:45 PM
  To: Bill Riley III
  Cc: cisco-voip at puck.nether.net
  Subject: RE: [cisco-voip] CDR report

  No dice.  We wrote our own.   For a third party take a look at Syn-Apps call accounting.  They do good stuff.

  Jon

  -----------------------------------------------

  Date: Wed, 29 Mar 2006 15:49:49 -0600
  From: "Bill Riley III" <BRiley at jackhenry.com>
  Subject: [cisco-voip] CDR report
  To: <cisco-voip at puck.nether.net>
  Message-ID:
  <13591CB4B2359F4D96E2606DD6B840A0024B7BBD at smoxchg.jhacorp.com>
  Content-Type: text/plain; charset="us-ascii"

  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? 
   

  Thanks,

  Bill Riley


                         All Content of this document is ADP Confidential 2006
  Jon Pritchard - Sr. Network Engineer
  Network Solutions Group
  ADP Dealer Services, 2525 SW First Avenue, Portland, OR 97201
  phone: (503) 205-4428, fax: (503) 402-3277
  email: Jon_Pritchard at adp.com






  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.



  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.




  _______________________________________________
  cisco-voip mailing list
  cisco-voip at puck.nether.net
  https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060329/ea82358c/attachment-0001.html