<div>WARNING!!! Use at your own risk. I am not responsible if you blow up your server or cause system issues by running SQL commands. Always, always, always test in a lab first.</div>
<div> </div>
<div>Set your terminal program (putty, etc.) to log output.</div>
<div> </div>
<div>In CUCM 6 it looks like this:</div>
<div> </div>
<div>run sql select calledpartynumber, datetimeorigination, finalcalledpartynumber from car:tbl_billing_data where finalcalledpartynumber = <your VM pilot number></div>
<div> </div>
<div>In CUCM 8 you use "<font color="#660066">run sql car select" instead of defining the CAR database with the table name. It might look like this if the row names are the same:</font></div>
<div><font color="#660066"></font> </div>
<div><font color="#660066">run sql car select </font><font color="#000000">calledpartynumber, datetimeorigination, finalcalledpartynumber from tbl_billing_data where finalcalledpartynumber = <your VM pilot number></font></div>
<div> </div>
<div>Open the saved output log with Excel as delimited (tab or space, I believe). Convert the epoch time to human readable time as described here:</div>
<div><a href="http://www.blindhog.net/convert-epoch-time-in-excel/">http://www.blindhog.net/convert-epoch-time-in-excel/</a></div>
<div> </div>
<div>Again, use at your own risk.</div>
<div class="gmail_quote"> </div>
<div class="gmail_quote"> </div>
<div class="gmail_quote">On Fri, Mar 2, 2012 at 5:03 AM, Robin Clayton <span dir="ltr"><<a href="mailto:Robin.Clayton@rrfa.org.uk">Robin.Clayton@rrfa.org.uk</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div lang="EN-GB" vlink="purple" link="blue">
<div>
<p class="MsoNormal">CCM7 & UC7</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Dear all,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I am trying to get a report of how many calls are going to voicemail rather than being answered. I have looked in CDR but can’t find a way to get this information, I have looked in unity but can’t find it either.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Any pointers???</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Cheers</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Robin</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt">=========================</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt">Robin Clayton</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt"> </span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt">Network Transition Manager</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt">Richard Rose Federation</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt">Richard Rose Central Academy</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt">Victoria Place</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt" lang="ES-TRAD">Carlisle</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt" lang="ES-TRAD">Cumbria</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt" lang="ES-TRAD">CA1 1LY</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt" lang="ES-TRAD"> </span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt" lang="ES-TRAD">Tel: 01228 822075</span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:10pt">www: <a href="http://www.rrfa.org.uk/" target="_blank">www.rrfa.org.uk</a></span></i></b></p>
<p class="MsoNormal"><b><i><span style="FONT-FAMILY:'Belfast Heavy SF','sans-serif';FONT-SIZE:10pt"> </span></i></b></p>
<p class="MsoNormal"> </p></div>
<p>--------------------------------------------------------------------------------------------------------------</p>
<p><b>Important Notice:</b></p>
<p>This e-mail and any attachment are confidentialand may be privileged <br>or otherwise protected from disclosure. It is solely intended for the<br>person(s) named above. If you are not the intended recipient, any <br>reading, use, disclosure, copying or distribution of all or parts of this <br>
e-mail or associated attachments is strictly prohibited. If you are not <br>an intended recipient, please notify the sender immediately by <br>replying to this message or by telephone and delete this e-mail and <br>any attachments permanently from your system. </p>
<b><a href="http://www.rrfa.org.uk/" target="_blank">The Richard Rose Federation</a></b> </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></blockquote></div><br>