That is a good idea too, where would I configure asterisk to log the channel status on that custom field?<br><br><br><br><br><br><div class="gmail_quote">On Sat, Jan 24, 2009 at 8:27 AM, David fire <span dir="ltr"><<a href="mailto:ddfire@gmail.com">ddfire@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">and what about add a custome field or setup a variable on outgoing calls and use the common cdr and then filtering by that field.<br>
David<br><br><div class="gmail_quote">2009/1/24 Tilghman Lesher <span dir="ltr"><<a href="mailto:tilghman@mail.jeffandtilghman.com" target="_blank">tilghman@mail.jeffandtilghman.com</a>></span><div><div></div><div class="Wj3C7c">
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div>On Friday 23 January 2009 18:22:16 Pascal Bruno wrote:<br>
> Is it possible to log just the outgoing calls using cdr_odbc into a custom<br>
> mysql database table?<br>
> my table will look like this:<br>
> ____________<br>
><br>
> | call_status |<br>
> |------------------ --|<br>
> | · id |<br>
> | · destination |<br>
> | · status |<br>
> |____________|<br>
><br>
> I just need to store the destination number and the status of the channel<br>
> for example BUSY, UNAVAILABLE etc...<br>
<br>
</div></div>Yes, if you install the cdr_adaptive_odbc backport. See the sample config<br>
file for more information.<br>
<br>
Web: <a href="http://svncommunity.digium.com/view/tilghman/branches/1.4" target="_blank">http://svncommunity.digium.com/view/tilghman/branches/1.4</a><br>
SVN: <a href="http://svncommunity.digium.com/svn/tilghman/branches/1.4" target="_blank">http://svncommunity.digium.com/svn/tilghman/branches/1.4</a><br>
<br>
--<br>
Tilghman<br>
<br>
_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div></div></div><font color="#888888"><br><br clear="all"><br>-- <br> (\__/) <br>(='.'=)This is Bunny. Copy and paste bunny into your <br>(")_(")signature to help him gain world domination. <br>
<br>
</font><br>_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br>