[cisco-voip] Help with CDR Export

[Keith Klevenski]

This should help some:
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note0
9186a00801d71c5.shtml#understand 

 

Keith Klevenski
IP Telephony Engineer

RigNet Inc.
1880 S. Dairy Ashford

Suite 300
Houston, TX 77077         

Office:   +1 281.674.0702
Mobile:  +1 713.677.3925

http://www.rig.net <http://www.rig.net/> 

 

"Extending the power of your knowledge"

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Rhodes, Geoff
Sent: Wednesday, July 11, 2007 8:48 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Help with CDR Export

 

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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070711/f31aa4ef/attachment.html