[cisco-voip] CDR question..

[gary.d.brinkman.jr at census.gov]

Not sure about 4.0 but on 3.3 you can run this query against the CDR
database and get what you need.  Just change the originalCalledPartyNumber
to the number you need.  And while 1128142800 is equivalent to 10/1/2005
12:00 AM  EST you may need to get a Epoch time converter to get a different
time.


SELECT     duration
FROM         CallDetailRecord
WHERE     (dateTimeOrigination > '1128142800') and
(originalCalledPartyNumber like '%8005551212')

-----

Gary D. Brinkman
U.S. Census Bureau
Telecommunications Office



                                                                           
             "Tim Reimers"                                                 
             <tim.reimers at ashe                                             
             ville.k12.nc.us>                                           To 
             Sent by:                  <cisco-voip at puck.nether.net>        
             cisco-voip-bounce                                          cc 
             s at puck.nether.net                                             
                                                                   Subject 
                                       [cisco-voip] CDR question..         
             11/30/05 11:26 AM                                             
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




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..
 _______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip