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

[Philip Walenta]

Something I've found handy in the past is to use MS Access.
 
Set up an ODBC link, then open it in access.  Access has enough capability
to let you pull what you want from the database, and build your own reports.
It might even have a routine to convert the time for you.


  _____  

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of James Grace
Sent: Friday, February 17, 2006 10:09 AM
To: 'Brian Henry'; 'Jonathan Charles'
Cc: cisco-voip at puck.nether.net
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



 

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