[cisco-voip] need to pull info out the cdr tables

[Lelio Fulgenzi]

PS, I wouldn't trust Access or a spreadsheet because I'm pretty sure it screws up DST

--------------------------------------------------------------------------------
Lelio Fulgenzi, B.A.
Network Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"I had a coffee and Coke at lunch today...and now, I've got more jitter than an
IP phone on a long haul 10base2 connection"                                           LFJ
  ----- Original Message ----- 
  From: Lelio Fulgenzi 
  To: James Grace ; 'Brian Henry' ; 'Jonathan Charles' 
  Cc: cisco-voip at puck.nether.net 
  Sent: Friday, February 17, 2006 11:23 AM
  Subject: Re: [cisco-voip] need to pull info out the cdr tables


  long live AWK

  /bin/awk -F, '{ print strftime("%m/%d/%Y %H:%M:%S",$1), $2, $3 ... $N}' 


  --------------------------------------------------------------------------------
  Lelio Fulgenzi, B.A.
  Network Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
  (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
  "I had a coffee and Coke at lunch today...and now, I've got more jitter than an
  IP phone on a long haul 10base2 connection"                                           LFJ
    ----- Original Message ----- 
    From: James Grace 
    To: 'Brian Henry' ; 'Jonathan Charles' 
    Cc: cisco-voip at puck.nether.net 
    Sent: Friday, February 17, 2006 11:08 AM
    Subject: RE: [cisco-voip] need to pull info out the cdr tables


    This is exactly what I needed.  Thank you  guys.  Hey is there something out there, a tool that allow me to convert multiple epoch time. Like in a spread sheet or text file 

     


----------------------------------------------------------------------------

    From: Brian Henry [mailto:Brian.Henry at apptis.com] 
    Sent: Thursday, February 16, 2006 3:38 PM
    To: Jonathan Charles; James Grace
    Cc: cisco-voip at puck.nether.net
    Subject: RE: [cisco-voip] need to pull info out the cdr tables

     

    That is correct or another example.

     

    select dateTimeOrigination, origIpAddr, callingPartyNumber, destIpAddr, originalCalledPartyNumber, finalCalledPartyNumber, dateTimeConnect, dateTimeDisconnect, lastRedirectDn, origDeviceName, destDeviceName from CallDetailRecord where callingPartyNumber = '3082'

     

    just remember that the time is in epcho time and needs manipulated.

     

    Brian

     


----------------------------------------------------------------------------

    From: cisco-voip-bounces at puck.nether.net on behalf of Jonathan Charles
    Sent: Thu 2/16/2006 3:29 PM
    To: James Grace
    Cc: cisco-voip at puck.nether.net
    Subject: Re: [cisco-voip] need to pull info out the cdr tables

    Here is a query we run to find 911 calls, you can modify as needed:

    use cdr    
    SELECT     dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber, originalCalledPartyNumber, duration
    FROM         CallDetailRecord    
    WHERE     (finalCalledPartyNumber = '911')    




    Jonathan

    On 2/16/06, James Grace <jgrace at digitelusa.net> wrote: 

    Im in a crunch to get some data from the cdr records.  Currently we are no able to run the cdr analyis and reporting pluging on our CM pub..  major issues with the tomcat and tcd services,they wont start.  But all the other setting are set up and data is populating in the cdr tables.  Can someone give me a basic sql query to pull out all calls in and out to a particular ext.

     

    James D. Grace 

    CCNP CCNA MCSE MCDBA

    Sr. System Engineer / Professional Svc.

    Digitel Corporation

     


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



     



----------------------------------------------------------------------------


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



------------------------------------------------------------------------------


  _______________________________________________
  cisco-voip mailing list
  cisco-voip at puck.nether.net
  https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060217/35fcc2c1/attachment-0001.html