[cisco-voip] Help with CDR Export

[Mike Lay (milay)]

A direct query into the CDR DB is NOT supported to collect CDR records.
Any certified 3rd party billing application will be using a custom
trigger that will populate the CDR DB & the 3rd party DB at the same
time. The reason for this is a query into the CDR DB can spike the CPU
on the Pub, not an optimal situation to be in.

Thanks,
Mike 

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Reto Gassmann
Sent: Wednesday, July 11, 2007 9:14 AM
To: Rhodes, Geoff
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Help with CDR Export

Hi Geoff

We do a direct ODBC access to the sql database on the publisher to get
the CDR data.

=A1/3600/24+(2/24)+25569 (where A1 is the field for the CDR time)
Format:
TT.MM.JJJJ hh:mm:ss

Have a good day
Reto

Zitat von "Rhodes, Geoff" <GRhodes at rbh.com>:

> I'm trying to run some reports for HR on a secretary and her calls.  
> All I want to get is a listing of all the calls the received and made 
> during a time period.  Doing a CDR search gives me tons of info, but I

> can't figure out the layout of the .TXT file.  It's actually been 
> easier to just do a CDR export and pull it into Excel, sort the data 
> and grab just the records I need.
>  
> The problem is the DateTime fields.  Anyone have a formula to change 
> this to a date HR can read?  I assume it's something like the number 
> of seconds since Call Manager was born, but any help is appreciated.
>  
> I know there has been discussions on here before about Call Manager's 
> reporting, but I wanted to say it again, it's really overly
complicated.
> Has anyone done anything using Crystal Reports against the CDR
database?
> I wonder if that would be easier?
>  
> Thanks in advance....
>  
> Geoff Rhodes
> Director, Information Technology
> Robinson, Bradshaw & Hinson, P.A.
> 704 / 377-8188
> grhodes at rbh.com
>  
> 
> 




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