[cisco-voip] CDR information

[Mike Armstrong]

I can add for (2): Excel.  It's relatively easy to gather the CDR data into 
Access, and from there to Excel.  Once in Excel, you can analyze the 
daylights out of it.

Mike Armstrong
UF/IFAS CREC
Lake Alfred, FL

> Date: Fri, 8 Dec 2006 13:23:55 -0500
> From: "Ed Leatherman" <ealeatherman at gmail.com>
> Subject: Re: [cisco-voip] CDR information
> To: "Joe A. Budz" <joe at budz.org>
> Cc: cisco-voip at puck.nether.net
> Message-ID:
> <94a1afde0612081023xee932bdlff9f0e539c3e7982 at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Joe,
>
> I can't help you with 1 & 2
> For your third question if you mean you need to convert the UTC time stamp
> then here are a few options;
>
> - you can convert it directly in your sql select statement :
> SELECT DATEADD(ss, datetimeorigination, 'Jan 1, 1970 00:00:00') AS
> datetime,  etc etc
>
> - You can convert in excel to GMT with this formula: =<Cell
> number>/86400+DATE(1970,1,1)
>
> - Find a converter on the net that will do it. There is one up for 
> download
> from www.ciscopress.com, look at this link and go to the downloads part
> http://www.ciscopress.com/bookstore/product.asp?isbn=1587050757&redir=1&rl=1
>
> Hope that helps
>
> On 12/8/06, Joe A. Budz <joe at budz.org> wrote:
>>
>> Three call record type questions
>> 1) Does anyone know a good source for CDR training information?
>> 2) Any good software that graphs real time and historical call data - I
>> want
>> to be able to analyze LD, local and internal calls as well as PRI trunk
>> utilization.
>> 3) Does anyone know how to interoperate the number in the time field of
>> the
>> SQL database?
>>
>>
>> Thank You,
>>
>> Joe A. Budz
>>
>> Network Operations Manager
>> Hahn Loeser + Parks LLP
>> Phone: 216.274.2338
>> Cell: 330.571.4849
>> Fax: 216-274-2507
>> e-mail: joe at hahnlaw.com
>>
>>
>
> -- 
> Ed Leatherman
> Senior Voice Engineer
> West Virginia University
> Telecommunications and Network Operations
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> https://puck.nether.net/pipermail/cisco-voip/attachments/20061208/726b9938/attachment-0001.html
>
> ------------------------------