[cisco-voip] CDR information

[Ed Leatherman]

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.html