[cisco-voip] CDR question

[Mike Armstrong]

Good point.  I do almost everything in Excel, and still don't have a nice 
way to deal with DST.  Of course, with Congress screwing around with the 
algorithm, very few programs are going to be able to deal with it nicely... 
:~).

Happy holidays all,

Mike Armstrong
UF/IFAS CREC
Lake Alfred, FL

> Date: Sun, 4 Dec 2005 02:49:13 -0500
> From: "Lelio Fulgenzi" <lelio at uoguelph.ca>
> Subject: Re: [cisco-voip] CDR question..
> To: "Stu Packett" <SPackett at fenwick.com>, "Tim Reimers"
> <tim.reimers at asheville.k12.nc.us>, <cisco-voip at puck.nether.net>
> Message-ID: <001901c5f8a7$38b0e0b0$ca01a8c0 at deadfish>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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..
>
>
>
>
> ------------------------------------------------------------------------------