Oh, yeah, forgot about that...<br>
<br>
Go here when you get the results to convert the time:<br>
<br>
<a href="http://www.forestasia.com/tools/epoch.asp">http://www.forestasia.com/tools/epoch.asp</a><br>
<br>
BTW, Epoch time is the number of seconds that have passed since January
1st, 1970... apparently this is the year 0 for Epoch time.<br>
<br>
<br>
<br>
J<br><br><div><span class="gmail_quote">On 2/16/06, <b class="gmail_sendername">Brian Henry</b> <<a href="mailto:Brian.Henry@apptis.com">Brian.Henry@apptis.com</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 dir="ltr">
<div dir="ltr"><font color="#000000" face="Arial" 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>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip-bounces@puck.nether.net</a> 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> <a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br><b>Subject:</b> Re:
[cisco-voip] need to pull info out the cdr tables<br></font><br></div><div><span class="e" id="q_1097496d02d4cfd0_1">
<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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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 href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br><br></blockquote></div><br></div>
</span></div></blockquote></div><br>