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

[Brian Henry]

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