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

[Jonathan Charles]

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