<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 12 (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]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
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","serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.emailstyle17
{mso-style-name:emailstyle17;}
span.balloontextchar0
{mso-style-name:balloontextchar;}
span.emailstyle171
{mso-style-name:emailstyle171;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.balloontextchar1
{mso-style-name:balloontextchar1;
font-family:"Tahoma","sans-serif";}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link="#000000" vlink="#000000">
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thanks for the response John, when I did this, this is all of
the info I received. Any other ideas?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>admin:run sql select * from car:tbl_billing_data where
callingPartyNumber='XXXX'<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>cdrrecordtype globalcallid_callmanagerid globalcallid_callid
origlegcallidentifi er
datetimeorigination orignodeid origspan origipaddr callingpartynumber
calling
partyunicodeloginuserid origcause_location origcause_value origprecedencelevel
o
rigmediatransportaddress_ip origmediatransportaddress_port origmediacap_payloadc
apability origmediacap_maxframesperpacket origmediacap_g723bitrate
origvideocap_ codec
origvideocap_bandwidth origvideocap_resolution
origvideotransportaddress_i
p origvideotransportaddress_port origrsvpaudiostat
origrsvpvideostat
destlegiden
tifier destnodeid destspan destipaddr originalcalledpartynumber
finalcalledparty
number finalcalledpartyunicodeloginuserid destcause_location destcause_value
des tprecedencelevel
destmediatransportaddress_ip destmediatransportaddress_port
des
tmediacap_payloadcapability
destmediacap_maxframesperpacket
destmediacap_g723bit
rate destvideocap_codec destvideocap_bandwidth destvideocap_resolution
destvideo
transportaddress_ip destvideotransportaddress_port destrsvpaudiostat destrsvpvid
eostat datetimeconnect datetimedisconnect lastredirectdn pkid
originalcalledpart ynumberpartition
callingpartynumberpartition finalcalledpartynumberpartition
las
tredirectdnpartition duration origdevicename destdevicename
origcallterminationo
nbehalfof destcallterminationonbehalfof origcalledpartyredirectonbehalfof
lastre
directredirectonbehalfof origcalledpartyredirectreason
lastredirectredirectreaso n
destconversationid globalcallid_clusterid joinonbehalfof comment seq_id
load_i
d charge_to user_id manager_id charge call_classification
call_type
datetimestam
porigination datetimestampconnect datetimestampdisconnect
orignumberpacketssent
orignumberoctetssent orignumberpacketsreceived orignumberoctetsreceived
orignumb erpacketslost
origjitter origlatency origquality_of_service
destnumberpacketssen
t destnumberoctetssent
destnumberpacketsreceived destnumberoctetsreceived
destnu
mberpacketslost destjitter destlatency destquality_of_service
authcodedescriptio
n authorizationlevel clientmattercode origdtmfmethod destdtmfmethod origvarvqmet
rics destvarvqmetrics callsecuredstatus origconversationid
origmediacap_bandwidt h
destmediacap_bandwidth authorizationcodevalue outpulsedcallingpartynumber
outp
ulsedcalledpartynumber origipv4v6addr destipv4v6addr<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>============= ========================== ===================
===================
== =================== ========== ======== ========== ==================
=======
======================= ================== =============== ===================
=
=========================== ==============================
===================== =========
=============================== ========================
=============
===== ====================== =======================
===========================
= ============================== ================= =================
===========
====== ========== ======== ========== =========================
================ ======
================================== ================== ===============
===
================
============================ ==============================
===
=========================== ===============================
====================
==== ================== ====================== =======================
========= ===================
============================== =================
=========== ======
=============== ================== ============== ====
==================
================ =========================== ===============================
===
==================== ======== ============== ============== ====================
========= ============================= =================================
====== ========================
=============================
=========================
= ================== ====================== ==============
======= ======
======
= ========= ======= ========== ====== =================== =========
============
============ ==================== =======================
===================== ====================
========================= ========================
========
============= ========== ===========
======================
====================
= ==================== ========================= ========================
======
=============== ========== =========== ======================
================== =
================== ================ ============== ==============
============ ====
================ ================= ==================
=====================
= ====================== ====================== ===========================
====
====================== ============== ==============<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><i><span style='font-size:13.5pt;font-family:"Arial","sans-serif";
color:#1F497D'>Tim Huffman</span></i><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Rosetta Stone®</span><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Cisco Telephony Administrator</span><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>T (540) 236-5077</span></b><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>(800) 788-0822</span><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>RosettaStone.com</span><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><img width=130 height=27 id="_x0000_i1026"
src="cid:image001.jpg@01CA824F.CA564880" alt=logo><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:#1F497D'>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='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On
Behalf Of </b>John Huston<br>
<b>Sent:</b> Monday, December 21, 2009 2:56 PM<br>
<b>To:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] Running Reports<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0in 0in 0in 0in'>
<div>
<p class=MsoNormal>You can try this example from the command line:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Trebuchet MS","sans-serif";
color:navy'>run sql select * from car:tbl_billing_data where </span><span
style='font-family:"Trebuchet MS","sans-serif";color:black'>callingPartyNumber</span><span
style='font-family:"Trebuchet MS","sans-serif";color:navy'>='1000'</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Trebuchet MS","sans-serif";
color:navy'>This would show you all of the activity from extension 1000</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><br>
<br>
--- On <b>Mon, 12/21/09, Huffman, Tim <i><thuffman@rosettastone.com></i></b>
wrote:<o:p></o:p></p>
</div>
<blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-bottom:12.0pt'><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<o:p></o:p></p>
<div id=yiv1820867602>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>All,<o:p></o:p></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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?<o:p></o:p></p>
</blockquote>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks,<o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><i><span
style='font-size:13.5pt;font-family:"Arial","sans-serif";color:#1F497D'>Tim
Huffman</span></i><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Rosetta
Stone®</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Cisco
Telephony Administrator</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>T
(540) 236-5077</span></b><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>(800)
788-0822</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>RosettaStone.com</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='color:#1F497D'><img width=130 height=27 id="Picture_x0020_1"
src="cid:image001.jpg@01CA824F.CA564880" alt=logo></span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#1F497D'>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><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
-----Inline Attachment Follows-----<o:p></o:p></p>
<div>
<p class=MsoNormal>_______________________________________________<br>
cisco-voip mailing list<br>
<a
href="http://us.mc800.mail.yahoo.com/mc/compose?to=cisco-voip@puck.nether.net"><u><span
style='color:blue'>cisco-voip@puck.nether.net</span></u></a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank"><u><span
style='color:blue'>https://puck.nether.net/mailman/listinfo/cisco-voip</span></u></a><o:p></o:p></p>
</div>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>