Hi Steve,<br><br>Yes you can. Might be able to do it with CAR but I dont use that unless I must. You can use the MS SQL query analyzer on the publisher to generate all kinds of useful information;<br><br>Load up the Query Analyzer from the start menu, use local authentication. Select the CDR database from the dropdown at the top.
<br><br>Query I like to use and modify (I think I got this one from Wes)<br><br>SELECT DATEADD(ss, datetimeorigination, 'Jan 1, 1970 00:00:00')<br> AS datetime, callingPartyNumber, originalcalledpartynumber,<br>
finalcalledpartynumber, duration, origdevicename, destdevicename <br>FROM calldetailrecord<br>WHERE callingPartyNumber = '39811'<br>ORDER BY datetimeorigination<br><br>Off the top of my head, you could search based on
<br>WHERE origdevicename = 'yourgatewaynamehere' OR origdevicename = 'yourothergatewaynamehere' <br>to get incoming calls (or there might be an better way)<br><br>Timestamps in the results are in GMT with that sql query.
<br><br>Ed<br><br><div><span class="gmail_quote">On 1/29/07, <b class="gmail_sendername">Miller, Steve</b> <<a href="mailto:MillerS@dicksteinshapiro.com">MillerS@dicksteinshapiro.com</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;">
<div bgcolor="#ffffff">
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2">
<div><font face="Arial" size="2">All I see are outgoing when I run a department
billing report. Please help!</font></div></font></div>
<div> </div></div></blockquote></div><br clear="all"><br>-- <br>Ed Leatherman<br>Senior Voice Engineer<br>West Virginia University<br>Telecommunications and Network Operations