<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">

<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:Tahoma;}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.emailstyle17
        {font-family:Arial;
        color:windowtext;}
span.EmailStyle18
        {font-family:Arial;
        color:navy;}
span.EmailStyle19
        {font-family:Arial;
        color:navy;}
@page Section1
        {size:595.3pt 841.9pt;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=EN-GB link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks for that Joe, I am a little
confused with the conversion of date and time though as I have no sql
experience, have you done this? </span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;font-family:
"Times New Roman"'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-weight:bold'>From:</span></font></b><font size=2><span
lang=EN-US style='font-size:10.0pt'> Joe Pollere (US)
[mailto:Joe.Pollere@us.didata.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, September 26, 2006
1:27 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Nick Kassel;
cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [cisco-voip] No of
calls made</span></font></p>

</div>

<p class=MsoNormal><font size=3 face=Tahoma><span style='font-size:12.0pt'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>You could use a sql query
to search the CDR database:</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><a
href="http://www.cisco.com/en/US/partner/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml">http://www.cisco.com/en/US/partner/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml</a></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;font-family:
"Times New Roman"'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-weight:bold'>From:</span></font></b><font size=2><span
lang=EN-US style='font-size:10.0pt'> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Nick Kassel<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, September 26, 2006
7:09 AM<br>
<b><span style='font-weight:bold'>To:</span></b> cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [cisco-voip] No of calls
made</span></font></p>

</div>

<p class=MsoNormal><font size=3 face=Tahoma><span lang=EN-US style='font-size:
12.0pt'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have been asked to try and find out how many calls the
Call Managers have made over the last 12 months, can anyone help with how to
extract this sort of information?</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-family:"Times New Roman"'>&nbsp;</span></font></p>

<table class=MsoNormalTable border=0 cellpadding=0 bgcolor=white
 style='background:white'>
 <tr>
  <td style='padding:.75pt .75pt .75pt .75pt'>
  <p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
  style='font-size:12.0pt;font-family:"Times New Roman";color:black'><br>
  ***********************************************************************************************<br>
  <br>
  The&nbsp;information&nbsp;contained&nbsp;in&nbsp;this&nbsp;e-mail&nbsp;is&nbsp;strictly&nbsp;confidential,&nbsp;some&nbsp;or&nbsp;all<br>
  of&nbsp;which&nbsp;may&nbsp;be&nbsp;legally&nbsp;privileged.&nbsp;It&nbsp;is&nbsp;for&nbsp;the&nbsp;intended&nbsp;recipient&nbsp;only.<br>
  Access&nbsp;to&nbsp;this&nbsp;e-mail&nbsp;by&nbsp;any&nbsp;other&nbsp;person&nbsp;is&nbsp;prohibited.&nbsp;If&nbsp;you&nbsp;are&nbsp;not&nbsp;the<br>
  intended&nbsp;recipient,&nbsp;any&nbsp;use,&nbsp;disclosure,&nbsp;copying,&nbsp;printing,&nbsp;distribution&nbsp;of,<br>
  replying&nbsp;to&nbsp;or&nbsp;any&nbsp;action&nbsp;taken&nbsp;or&nbsp;omitted&nbsp;to&nbsp;be&nbsp;taken&nbsp;in&nbsp;reliance&nbsp;on&nbsp;this<br>
  e-mail,&nbsp;is&nbsp;prohibited&nbsp;and&nbsp;may&nbsp;be&nbsp;unlawful.&nbsp;Please&nbsp;contact&nbsp;the&nbsp;sender&nbsp;immediately<br>
  should&nbsp;this&nbsp;e-mail&nbsp;have&nbsp;been&nbsp;incorrectly&nbsp;addressed&nbsp;or&nbsp;transmitted.<br>
  <br>
  You&nbsp;accept&nbsp;that&nbsp;any&nbsp;instructions&nbsp;are&nbsp;deemed&nbsp;to&nbsp;have&nbsp;been&nbsp;given&nbsp;at&nbsp;the&nbsp;time&nbsp;the<br>
  recipient(s)&nbsp;accesses&nbsp;them&nbsp;and&nbsp;that&nbsp;delivery&nbsp;receipt&nbsp;does&nbsp;not&nbsp;constitute<br>
  acknowledgement&nbsp;or&nbsp;receipt&nbsp;by&nbsp;the&nbsp;intended&nbsp;recipient(s).&nbsp;You&nbsp;accept&nbsp;that&nbsp;there<br>
  may&nbsp;be&nbsp;a&nbsp;delay&nbsp;in&nbsp;processing&nbsp;the&nbsp;instructions&nbsp;received&nbsp;from&nbsp;e-mails&nbsp;after<br>
  Charles&nbsp;Stanley&nbsp;has&nbsp;received&nbsp;them.&nbsp;You&nbsp;are&nbsp;advised&nbsp;that&nbsp;urgent,&nbsp;time&nbsp;sensitive<br>
  and&nbsp;confidential&nbsp;communications&nbsp;should&nbsp;not&nbsp;be&nbsp;sent&nbsp;by&nbsp;e-mail.&nbsp;<br>
  <br>
  You&nbsp;acknowledge&nbsp;that&nbsp;e-mails&nbsp;are&nbsp;not&nbsp;secure&nbsp;and&nbsp;you&nbsp;accept&nbsp;the&nbsp;risk&nbsp;of<br>
  malfunction,&nbsp;viruses,&nbsp;unauthorised&nbsp;interference,&nbsp;mis-delivery&nbsp;or&nbsp;delay.<br>
  ************************************************************************************************<br>
  <br>
  <br>
  Charles&nbsp;Stanley&nbsp;&amp;&nbsp;Co.&nbsp;Ltd<br>
  Registered&nbsp;Office:&nbsp;25&nbsp;Luke&nbsp;Street&nbsp;London&nbsp;EC2A&nbsp;4AR<br>
  <br>
  Tel:&nbsp;0207&nbsp;739&nbsp;8200&nbsp;Fax:&nbsp;0207&nbsp;739&nbsp;7798<br>
  Registered&nbsp;in&nbsp;England&nbsp;No.&nbsp;1903304<br>
  <br>
  Charles&nbsp;Stanley&nbsp;Sutherlands&nbsp;and&nbsp;Charles&nbsp;Stanley&nbsp;Securities&nbsp;are&nbsp;divisions&nbsp;of&nbsp;Charles&nbsp;Stanley&nbsp;&amp;&nbsp;Co.&nbsp;Ltd<br>
  <br>
  Authorised&nbsp;and&nbsp;Regulated&nbsp;by&nbsp;the&nbsp;Financial&nbsp;Services&nbsp;Authority,&nbsp;Member&nbsp;of&nbsp;the<br>
   London&nbsp;Stock&nbsp;Exchange,&nbsp;International&nbsp;Securities&nbsp;Markets&nbsp;Association,&nbsp;and&nbsp;The&nbsp;London&nbsp;International&nbsp;Financial&nbsp;Futures&nbsp;&amp;<br>
  Options&nbsp;Exchange.<br>
  <br>
  This&nbsp;footnote&nbsp;also&nbsp;confirms&nbsp;that&nbsp;this&nbsp;email&nbsp;message&nbsp;has&nbsp;been&nbsp;swept&nbsp;by&nbsp;McAfee<br>
  VirusScan&nbsp;and&nbsp;SurfControl&nbsp;Email&nbsp;Filter&nbsp;software.</span></font></p>
  </td>
 </tr>
</table>

<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt;font-family:"Times New Roman"'>&nbsp;</span></font></p>

</div>

<br><br><table bgcolor=white style="color:black"><tr><td><br>***********************************************************************************************<br>
<br>
The&nbsp;information&nbsp;contained&nbsp;in&nbsp;this&nbsp;e-mail&nbsp;is&nbsp;strictly&nbsp;confidential,&nbsp;some&nbsp;or&nbsp;all<br>
of&nbsp;which&nbsp;may&nbsp;be&nbsp;legally&nbsp;privileged.&nbsp;It&nbsp;is&nbsp;for&nbsp;the&nbsp;intended&nbsp;recipient&nbsp;only.<br>
Access&nbsp;to&nbsp;this&nbsp;e-mail&nbsp;by&nbsp;any&nbsp;other&nbsp;person&nbsp;is&nbsp;prohibited.&nbsp;If&nbsp;you&nbsp;are&nbsp;not&nbsp;the<br>
intended&nbsp;recipient,&nbsp;any&nbsp;use,&nbsp;disclosure,&nbsp;copying,&nbsp;printing,&nbsp;distribution&nbsp;of,<br>
replying&nbsp;to&nbsp;or&nbsp;any&nbsp;action&nbsp;taken&nbsp;or&nbsp;omitted&nbsp;to&nbsp;be&nbsp;taken&nbsp;in&nbsp;reliance&nbsp;on&nbsp;this<br>
e-mail,&nbsp;is&nbsp;prohibited&nbsp;and&nbsp;may&nbsp;be&nbsp;unlawful.&nbsp;Please&nbsp;contact&nbsp;the&nbsp;sender&nbsp;immediately<br>
should&nbsp;this&nbsp;e-mail&nbsp;have&nbsp;been&nbsp;incorrectly&nbsp;addressed&nbsp;or&nbsp;transmitted.<br>
<br>
You&nbsp;accept&nbsp;that&nbsp;any&nbsp;instructions&nbsp;are&nbsp;deemed&nbsp;to&nbsp;have&nbsp;been&nbsp;given&nbsp;at&nbsp;the&nbsp;time&nbsp;the<br>
recipient(s)&nbsp;accesses&nbsp;them&nbsp;and&nbsp;that&nbsp;delivery&nbsp;receipt&nbsp;does&nbsp;not&nbsp;constitute<br>
acknowledgement&nbsp;or&nbsp;receipt&nbsp;by&nbsp;the&nbsp;intended&nbsp;recipient(s).&nbsp;You&nbsp;accept&nbsp;that&nbsp;there<br>
may&nbsp;be&nbsp;a&nbsp;delay&nbsp;in&nbsp;processing&nbsp;the&nbsp;instructions&nbsp;received&nbsp;from&nbsp;e-mails&nbsp;after<br>
Charles&nbsp;Stanley&nbsp;has&nbsp;received&nbsp;them.&nbsp;You&nbsp;are&nbsp;advised&nbsp;that&nbsp;urgent,&nbsp;time&nbsp;sensitive<br>
and&nbsp;confidential&nbsp;communications&nbsp;should&nbsp;not&nbsp;be&nbsp;sent&nbsp;by&nbsp;e-mail.&nbsp;<br>
<br>
You&nbsp;acknowledge&nbsp;that&nbsp;e-mails&nbsp;are&nbsp;not&nbsp;secure&nbsp;and&nbsp;you&nbsp;accept&nbsp;the&nbsp;risk&nbsp;of<br>
malfunction,&nbsp;viruses,&nbsp;unauthorised&nbsp;interference,&nbsp;mis-delivery&nbsp;or&nbsp;delay.<br>
************************************************************************************************<br>
<br>
<br>
Charles&nbsp;Stanley&nbsp;&amp;&nbsp;Co.&nbsp;Ltd<br>
Registered&nbsp;Office:&nbsp;25&nbsp;Luke&nbsp;Street&nbsp;London&nbsp;EC2A&nbsp;4AR<br>
<br>
Tel:&nbsp;0207&nbsp;739&nbsp;8200&nbsp;Fax:&nbsp;0207&nbsp;739&nbsp;7798<br>
Registered&nbsp;in&nbsp;England&nbsp;No.&nbsp;1903304<br>
<br>
Charles&nbsp;Stanley&nbsp;Sutherlands&nbsp;and&nbsp;Charles&nbsp;Stanley&nbsp;Securities&nbsp;are&nbsp;divisions&nbsp;of&nbsp;Charles&nbsp;Stanley&nbsp;&amp;&nbsp;Co.&nbsp;Ltd<br>
<br>
Authorised&nbsp;and&nbsp;Regulated&nbsp;by&nbsp;the&nbsp;Financial&nbsp;Services&nbsp;Authority,&nbsp;Member&nbsp;of&nbsp;the<br>
London&nbsp;Stock&nbsp;Exchange,&nbsp;International&nbsp;Securities&nbsp;Markets&nbsp;Association,&nbsp;and&nbsp;The&nbsp;London&nbsp;International&nbsp;Financial&nbsp;Futures&nbsp;&amp;<br>
Options&nbsp;Exchange.<br>
<br>
This&nbsp;footnote&nbsp;also&nbsp;confirms&nbsp;that&nbsp;this&nbsp;email&nbsp;message&nbsp;has&nbsp;been&nbsp;swept&nbsp;by&nbsp;McAfee<br>
VirusScan&nbsp;and&nbsp;SurfControl&nbsp;Email&nbsp;Filter&nbsp;software.<br>
</td></tr></table></body>

</html>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
Disclaimer:

This e-mail communication and any attachments may contain confidential and privileged information and is for use by the designated addressee(s) named above only.  If you are not the intended addressee, you are hereby notified that you have received this communication in error and that any use or reproduction of this email or its contents is strictly prohibited and may be unlawful.  If you have received this communication in error, please notify us immediately by replying to this message and deleting it from your computer. Thank you.
</STRONG></P></BODY>