<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV>
<DIV dir=ltr align=left><SPAN class=918583707-04122005><FONT face=Tahoma
color=#0000ff size=2>I do similar CDR queries as well when someone inadvertantly
dials 911. I have an Excel spreadsheet that makes it easier for me.
The date that the CDR reports is the number of seconds (or minutes?) from
January 1, 1970. So I have a field in Excel that says: <FONT
size=2>=A1/86400+DATE(1970,1,1) that converts the numbers into dates. If
this isn't that clear, I can send my CDR template for Excel that I always
use.</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=918583707-04122005><FONT face=Tahoma color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=918583707-04122005><FONT face=Tahoma color=#0000ff size=2>The
CDR query I would run in SQL Query Analzyer is:</FONT></SPAN></DIV>
<DIV><SPAN class=918583707-04122005></SPAN><SPAN class=918583707-04122005><FONT
face=Tahoma color=#0000ff size=2><FONT size=2>select
*</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=918583707-04122005><FONT face=Tahoma color=#0000ff size=2><FONT
size=2>from CallDetailRecord</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=918583707-04122005><FONT face=Tahoma color=#0000ff size=2><FONT
size=2>where finalCalledPartyNumber LIKE '91800%'</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=918583707-04122005><FONT face=Tahoma color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><FONT color=#0000ff><SPAN
class=918583707-04122005>Hope this helps.</SPAN><SPAN
class=918583707-04122005></DIV></SPAN></FONT></FONT></FONT>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff size=2></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Tim
Reimers<BR><B>Sent:</B> Wednesday, November 30, 2005 8:26 AM<BR><B>To:</B>
cisco-voip@puck.nether.net<BR><B>Subject:</B> [cisco-voip] CDR
question..<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi
everyone---<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have a CDR newbie kind of
question---<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can someone give me the steps needed
to determine the following: (CCM 4.0)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">All calls to a given 800 number in
say, the last two months…<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Number of
calls<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Duration of each
call<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">If I can get it into Excel I can
munge around the data to get the right things I want in terms of averages,
etc…<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">But I’ve not done any CDR stuff as
yet..<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P></DIV></DIV>
<DIV>
<HR>
</DIV>
<DIV>
<FONT FACE="Tahoma" COLOR="silver" SIZE="2">IRS Circular 230 Disclosure: To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. federal tax advice in this communication (including attachments) is not intended or written by Fenwick & West LLP to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing, or recommending to another party any transaction or matter addressed herein.</FONT>
</DIV>
<DIV>
<FONT FACE="Tahoma" COLOR="silver" SIZE="1">
<HR>
ATTENTION:<BR>The information contained in this message may be legally privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited.</FONT>
</DIV>
<DIV>
<FONT COLOR="silver">
</FONT>
<FONT FACE="Tahoma" SIZE="1"> </FONT>
</DIV>
<DIV>
<FONT FACE="Tahoma" COLOR="silver" SIZE="1">If you have received this message in error, please immediately notify the sender and/or Fenwick & West LLP by telephone at (650) 988-8500 and delete or destroy any copy of this message.</FONT>
</DIV></BODY></HTML>