<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<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 bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Something to worry about with Excel is the
conversion of daylight saving time correctly. Our LD billing office uses Excel
and they have to do some manual modifications to account for it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Just a thought.</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=SPackett@fenwick.com href="mailto:SPackett@fenwick.com">Stu
Packett</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=tim.reimers@asheville.k12.nc.us
href="mailto:tim.reimers@asheville.k12.nc.us">Tim Reimers</A> ; <A
title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, December 04, 2005 2:44
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [cisco-voip] CDR
question..</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>cisco-voip mailing
list<BR>cisco-voip@puck.nether.net<BR>https://puck.nether.net/mailman/listinfo/cisco-voip<BR></BLOCKQUOTE></BODY></HTML>