[cisco-voip] CDR question..

[Lelio Fulgenzi]

Something to worry about with Excel is the conversion of daylight saving time correctly. Our LD billing office uses Excel and they have to do some manual modifications to account for it.

Just a thought.

  ----- Original Message ----- 
  From: Stu Packett 
  To: Tim Reimers ; cisco-voip at puck.nether.net 
  Sent: Sunday, December 04, 2005 2:44 AM
  Subject: RE: [cisco-voip] CDR question..


  I do similar CDR queries as well when someone inadvertantly dials 911.  I have an Excel spreadsheet that makes it easier for me.  The date that the CDR reports is the number of seconds (or minutes?) from January 1, 1970.  So I have a field in Excel that says:  =A1/86400+DATE(1970,1,1) that converts the numbers into dates.  If this isn't that clear, I can send my CDR template for Excel that I always use.

  The CDR query I would run in SQL Query Analzyer is:
  select *
  from CallDetailRecord
  where finalCalledPartyNumber LIKE '91800%'

  Hope this helps.



------------------------------------------------------------------------------
  From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Tim Reimers
  Sent: Wednesday, November 30, 2005 8:26 AM
  To: cisco-voip at puck.nether.net
  Subject: [cisco-voip] CDR question..


  Hi everyone---



  I have a CDR newbie kind of question---



  Can someone give me the steps needed to determine the following:  (CCM 4.0)



  All calls to a given 800 number in say, the last two months.



  Number of calls

  Duration of each call



  If I can get it into Excel I can munge around the data to get the right things I want in terms of averages, etc.



  But I've not done any CDR stuff as yet..




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

  IRS Circular 230  Disclosure:  To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. federal tax advice in this communication (including attachments) is not intended or written by Fenwick & West LLP to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing, or recommending to another party any transaction or matter addressed herein. 

------------------------------------------------------------------------------
  ATTENTION:
  The information contained in this message may be legally privileged and confidential.  It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. 
   
  If you have received this message in error, please immediately notify the sender and/or Fenwick & West LLP by telephone at (650) 988-8500 and delete or destroy any copy of this message. 


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


  _______________________________________________
  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/20051204/143b315a/attachment.html