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

[James Grace]

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/7d09d019/attachment.html