<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=unicode">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText39862 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>That is correct or another
example.</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>select dateTimeOrigination, origIpAddr, callingPartyNumber,
destIpAddr, originalCalledPartyNumber, finalCalledPartyNumber, dateTimeConnect,
dateTimeDisconnect, lastRedirectDn, origDeviceName, destDeviceName from
CallDetailRecord where callingPartyNumber = '3082'</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>just remember that the time is in epcho time and needs
manipulated.</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Brian</DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net on
behalf of Jonathan Charles<BR><B>Sent:</B> Thu 2/16/2006 3:29 PM<BR><B>To:</B>
James Grace<BR><B>Cc:</B> cisco-voip@puck.nether.net<BR><B>Subject:</B> Re:
[cisco-voip] need to pull info out the cdr tables<BR></FONT><BR></DIV>
<DIV>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="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<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
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
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></DIV></BODY></HTML>