<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>You can try this example from the command line:</DIV>
<DIV> </DIV>
<DIV><FONT color=#000080 face="Trebuchet MS">run sql select * from car:tbl_billing_data where <FONT color=#000000>callingPartyNumber</FONT>='1000'</FONT></DIV>
<DIV><FONT color=#000080 face="Trebuchet MS"></FONT> </DIV>
<DIV><FONT color=#000080 face="Trebuchet MS">This would show you all of the activity from extension 1000</FONT></DIV>
<DIV><FONT color=#000080 face="Trebuchet MS"></FONT> </DIV>
<DIV><BR><BR>--- On <B>Mon, 12/21/09, Huffman, Tim <I><thuffman@rosettastone.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"><BR>From: Huffman, Tim <thuffman@rosettastone.com><BR>Subject: [cisco-voip] Running Reports<BR>To: "cisco-voip@puck.nether.net" <cisco-voip@puck.nether.net><BR>Date: Monday, December 21, 2009, 1:03 PM<BR><BR>
<DIV id=yiv1820867602>
<STYLE>
<!--
#yiv1820867602
_filtered #yiv1820867602 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv1820867602 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv1820867602
#yiv1820867602 p.MsoNormal, #yiv1820867602 li.MsoNormal, #yiv1820867602 div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}
#yiv1820867602 a:link, #yiv1820867602 span.MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv1820867602 a:visited, #yiv1820867602 span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv1820867602 p.MsoAcetate, #yiv1820867602 li.MsoAcetate, #yiv1820867602 div.MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";}
#yiv1820867602 span.EmailStyle17
{font-family:"Calibri", "sans-serif";color:windowtext;}
#yiv1820867602 span.BalloonTextChar
{font-family:"Tahoma", "sans-serif";}
#yiv1820867602 .MsoChpDefault
{}
_filtered #yiv1820867602 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv1820867602 div.Section1
{}
-->
</STYLE>
<DIV class=Section1>
<P class=MsoNormal>All,</DIV>
<P class=MsoNormal> </DIV>
<P class=MsoNormal>I need to be able to run reports what will tell me all activity from a phone for a date range. I’m in the CDR Analysis and Reporting tool running CDR -> Search -> By User/Extension. The extension that I’m using is not giving me any data for the date range when I know for a fact it was being used. Any other reports I can run, or anything I’m doing wrong?</DIV>
<P class=MsoNormal> </DIV>
<P class=MsoNormal>Thanks,</DIV>
<P class=MsoNormal> </DIV>
<P class=MsoNormal><I><SPAN style="FONT-FAMILY: 'Arial', 'sans-serif'; COLOR: #1f497d; FONT-SIZE: 13.5pt">Tim Huffman</SPAN></I><SPAN style="FONT-FAMILY: 'Times New Roman', 'serif'; COLOR: #1f497d; FONT-SIZE: 12pt"></SPAN></DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial', 'sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">Rosetta Stone®</SPAN><SPAN style="COLOR: #1f497d"></SPAN></DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial', 'sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">Cisco Telephony Administrator</SPAN><SPAN style="COLOR: #1f497d"></SPAN></DIV>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial', 'sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">T (540) 236-5077</SPAN></B><SPAN style="COLOR: #1f497d"></SPAN></DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial', 'sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">(800) 788-0822</SPAN><SPAN style="COLOR: #1f497d"></SPAN></DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial', 'sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">RosettaStone.com</SPAN><SPAN style="COLOR: #1f497d"></SPAN></DIV>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><IMG id=Picture_x0020_1 alt=logo src="cid:1.2548659333@web80010.mail.sp1.yahoo.com" width=130 height=27></SPAN></DIV>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial', 'sans-serif'; COLOR: #1f497d; FONT-SIZE: 7.5pt">This e-mail and any attachments thereto are intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you receive this email in error please contact the sender by reply email and destroy all copies of the original message.</SPAN></B><SPAN style="COLOR: #1f497d"></SPAN></DIV>
<P class=MsoNormal> </DIV></DIV></DIV><BR>-----Inline Attachment Follows-----<BR><BR>
<DIV class=plainMail>_______________________________________________<BR>cisco-voip mailing list<BR><A href="http://us.mc800.mail.yahoo.com/mc/compose?to=cisco-voip@puck.nether.net" ymailto="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></DIV></BLOCKQUOTE></td></tr></table>