[cisco-voip] CDR question..

[Stu Packett]

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

IRS Circular 230  Disclosure:  To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. federal tax advice in this communication (including attachments) is not intended or written by Fenwick & West LLP to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing, or recommending to another party any transaction or matter addressed herein.
--------------------------------------------------------

ATTENTION:
The information contained in this message may be legally privileged and confidential.  It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited.
 
If you have received this message in error, please immediately notify the sender and/or Fenwick & West LLP by telephone at (650) 988-8500 and delete or destroy any copy of this message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20051204/5456d9b6/attachment.html