CDR Default Table Specification?

Report
Question
I am using adaptive ODBC and I would like to create a table for the default CDR fields build into Asterisk. I managed to find several third party resources, but no official resource including the table specification for the default CDR fields. Where can I officially find this table specification, therefore data types and lengths etc. for each field?

Thank you very much :-)
Asterisk Users 3.1 years ago 3 Answers

Answers ( 3 )

  1. Andrew White
    +1
    August 19, 2012 at 19:45 pm
    Reply

    Hey Stefan,

    Have you had a look at http://www.voip-info.org/wiki/view/Asterisk+cdr+odbc? Voip-info.org isn't official, but it's a pretty good site.

    Have a look under "Setting up the CDR Database/Table".

    There's also the AST:

    https://wiki.asterisk.org/wiki/display/AST/MSSQL+CDR+Backend https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend

    Good luck!

    From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Stefan at WPF Sent: Monday, 20 August 2012 6:51 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] CDR default table specification?

    I am using adaptive ODBC and I would like to create a table for the default CDR fields build into Asterisk. I managed to find several third party resources, but no official resource including the table specification for the default CDR fields. Where can I officially find this table specification, therefore data types and lengths etc. for each field?

    Thank you very much :-)

  2. Stefan at
    +1
    August 23, 2012 at 06:54 am
    Reply

    Andrew, thank you very much, I like especially https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend as it's quite official :-) Dumb question, AST = asterisk or is it by chance just a part of asterisk or sth. like this?

    2012/8/20 Andrew White

  3. Andrew White
    +1
    August 23, 2012 at 19:33 pm
    Reply

    No worries - took me quite a while to find myself ages ago!

    Whoops, I just meant to say the wiki, not the "AST". I assume the AST in the url refers to Asterisk.

    From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Stefan at WPF Sent: Thursday, 23 August 2012 9:53 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR default table specification?

    Andrew, thank you very much, I like especially https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend as it's quite official :-) Dumb question, AST = asterisk or is it by chance just a part of asterisk or sth. like this? 2012/8/20 Andrew White > Hey Stefan,

    Have you had a look at http://www.voip-info.org/wiki/view/Asterisk+cdr+odbc? Voip-info.org isn't official, but it's a pretty good site.

    Have a look under "Setting up the CDR Database/Table".

    There's also the AST:

    https://wiki.asterisk.org/wiki/display/AST/MSSQL+CDR+Backend https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend

    Good luck!

    From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Stefan at WPF Sent: Monday, 20 August 2012 6:51 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] CDR default table specification?

    I am using adaptive ODBC and I would like to create a table for the default CDR fields build into Asterisk. I managed to find several third party resources, but no official resource including the table specification for the default CDR fields. Where can I officially find this table specification, therefore data types and lengths etc. for each field?

    Thank you very much :-)

 Prev question

Next question