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 :-)

3 Responses to “CDR Default Table Specification?”

  1. Andrew White said:

    Aug 19, 12 at 7:45 pm

    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 said:

    Aug 23, 12 at 6:54 am

    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 said:

    Aug 23, 12 at 7:33 pm

    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 :-)