Here is a query we run to find 911 calls, you can modify as needed:<br>
<br>
use cdr <br>
SELECT dateTimeOrigination, callingPartyNumber,
finalCalledPartyNumber, originalCalledPartyNumber, duration<br>
FROM CallDetailRecord <br>
WHERE (finalCalledPartyNumber = '911') <br>
<br>
<br>
<br>
<br>
Jonathan<br><br><div><span class="gmail_quote">On 2/16/06, <b class="gmail_sendername">James Grace</b> <<a href="mailto:jgrace@digitelusa.net">jgrace@digitelusa.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">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.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="4"><span style="font-size: 13.5pt; font-family: Arial;">James D. Grace</span></font><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><strong><b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">CCNP CCNA MCSE MCDBA</span></font></b></strong></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Sr. System Engineer / Professional Svc.</span></font></p>
<p><strong><b><font face="Baskerville Old Face" size="3"><span style="font-size: 12pt;">Digitel Corporation</span></font></b></strong></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
<br>_______________________________________________<br>cisco-voip mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">
https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br><br></blockquote></div><br>