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

[Lelio Fulgenzi]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060217/6dc53598/attachment.html