<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Baskerville Old Face";
panose-1:2 2 6 2 8 5 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>This is exactly what I needed. Thank you
guys. Hey is there something out there, a tool that allow me to convert
multiple epoch time. Like in a spread sheet or text file <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Brian Henry
[mailto:Brian.Henry@apptis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 16, 2006
3:38 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Jonathan Charles; James Grace<br>
<b><span style='font-weight:bold'>Cc:</span></b> <st1:PersonName w:st="on">cisco-voip@puck.nether.net</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [cisco-voip] need to
pull info out the cdr tables</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div id=idOWAReplyText39862>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>That is correct or another example.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>select dateTimeOrigination, origIpAddr, callingPartyNumber, destIpAddr,
originalCalledPartyNumber, finalCalledPartyNumber, dateTimeConnect,
dateTimeDisconnect, lastRedirectDn, origDeviceName, destDeviceName from CallDetailRecord
where callingPartyNumber = '3082'<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>just remember that the time is in epcho time and needs manipulated.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Brian<o:p></o:p></span></font></p>
</div>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
cisco-voip-bounces@puck.nether.net on behalf of Jonathan Charles<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thu 2/16/2006 3:29 PM<br>
<b><span style='font-weight:bold'>To:</span></b> James Grace<br>
<b><span style='font-weight:bold'>Cc:</span></b> <st1:PersonName w:st="on">cisco-voip@puck.nether.net</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [cisco-voip] need to
pull info out the cdr tables</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>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<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 2/16/06, <b><span style='font-weight:bold'>James
Grace</span></b> <<a href="mailto:jgrace@digitelusa.net">jgrace@digitelusa.net</a>>
wrote:</span></font></span> <o:p></o:p></p>
<div>
<p><font size=2 face=Arial><span style='font-size:10.0pt;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><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p><font size=4 face=Arial><span style='font-size:13.5pt;font-family:Arial'>James
D. Grace</span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font><o:p></o:p></p>
<p><strong><b><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'>CCNP CCNA MCSE MCDBA</span></font></b></strong><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Sr.
System Engineer / Professional Svc.</span></font><o:p></o:p></p>
<p><strong><b><font size=3 face="Baskerville Old Face"><span style='font-size:
12.0pt;font-family:"Baskerville Old Face"'>Digitel Corporation</span></font></b></strong><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><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>
<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</div>
</body>
</html>