Hi Joe,<br><br>I can't help you with 1 & 2<br>For your third question if you mean you need to convert the UTC time stamp then here are a few options;<br><br>- you can convert it directly in your sql select statement :
<br>SELECT DATEADD(ss, datetimeorigination, 'Jan 1, 1970 00:00:00') AS datetime, etc etc<br><br>- You can convert in excel to GMT with this formula: =<Cell number>/86400+DATE(1970,1,1)<br><br>- Find a converter on the net that will do it. There is one up for download from
<a href="http://www.ciscopress.com">www.ciscopress.com</a>, look at this link and go to the downloads part <a href="http://www.ciscopress.com/bookstore/product.asp?isbn=1587050757&redir=1&rl=1">http://www.ciscopress.com/bookstore/product.asp?isbn=1587050757&redir=1&rl=1
</a><br><br>Hope that helps<br><br><div><span class="gmail_quote">On 12/8/06, <b class="gmail_sendername">Joe A. Budz</b> <<a href="mailto:joe@budz.org">joe@budz.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Three call record type questions<br>1) Does anyone know a good source for CDR training information?<br>2) Any good software that graphs real time and historical call data - I want<br>to be able to analyze LD, local and internal calls as well as PRI trunk
<br>utilization.<br>3) Does anyone know how to interoperate the number in the time field of the<br>SQL database?<br><br><br>Thank You,<br><br>Joe A. Budz<br><br>Network Operations Manager<br>Hahn Loeser + Parks LLP<br>Phone:
216.274.2338<br>Cell: 330.571.4849<br>Fax: 216-274-2507<br>e-mail: <a href="mailto:joe@hahnlaw.com">joe@hahnlaw.com</a><br><br></blockquote></div><br clear="all"><br>-- <br>Ed Leatherman<br>Senior Voice Engineer<br>West Virginia University
<br>Telecommunications and Network Operations