I HAVE A DREAM Create XiVO UCP & CDR GUI

Sylvain Boily

Active Member
Joined
Apr 30, 2016
Messages
259
Reaction score
144
Location
Quebec
@wardmundy can you give me all informations you think it's important to have in our CDR? Maybe it will be interesting to add it in XiVO.
 

wardmundy

Nerd Uno
Joined
Oct 12, 2007
Messages
15,231
Reaction score
2,666
This still needs a little work. What I previously provided was the database file structure for the cdr table in asteriskcdrdb. The way the data is actually displayed obviously can be (and is) different. But here's the MySQL table structure:
Code:
cdr

Column    Type    Null    Default    Comments
calldate    datetime    No     0000-00-00 00:00:00    
clid    varchar(80)    No          
src    varchar(80)    No          
dst    varchar(80)    No          
dcontext    varchar(80)    No          
channel    varchar(80)    No          
dstchannel    varchar(80)    No          
lastapp    varchar(80)    No          
lastdata    varchar(80)    No          
duration    int(11)    No     0    
billsec    int(11)    No     0    
disposition    varchar(45)    No          
amaflags    int(11)    No     0    
accountcode    varchar(20)    No          
uniqueid    varchar(32)    No          
userfield    varchar(255)    No          
did    varchar(50)    No          
recordingfile    varchar(255)    No          
cnum    varchar(40)    No          
cnam    varchar(40)    No          
outbound_cnum    varchar(40)    No          
outbound_cnam    varchar(40)    No          
dst_cnam    varchar(40)    No          
Indexes: Documentation

Keyname    Type    Unique    Packed    Column    Cardinality    Collation    Null    Comment
calldate    BTREE    No    No    calldate    0    A      
dst    BTREE    No    No    dst    0    A      
accountcode    BTREE    No    No    accountcode    0    A      
uniqueid    BTREE    No    No    uniqueid    0    A      
did    BTREE    No    No    did    0    A      


Space usage:
Type    Usage
Data    2,224    B
Index    6,144    B
Total    8,368    B
     Row Statistics:
Statements    Value
Format    dynamic
Rows    13
Row length ø    171
Row size  ø    644 B
Creation    Jul 06, 2015 at 09:48 AM
Last update    Jul 07, 2015 at 12:30 PM
 

wardmundy

Nerd Uno
Joined
Oct 12, 2007
Messages
15,231
Reaction score
2,666
There's also a CEL table that looks like this in asteriskcdrdb:
Code:
cel

Column    Type    Null    Default    Comments
id    int(11)    No          
eventtype    varchar(30)    No          
eventtime    datetime    No          
cid_name    varchar(80)    No          
cid_num    varchar(80)    No          
cid_ani    varchar(80)    No          
cid_rdnis    varchar(80)    No          
cid_dnid    varchar(80)    No          
exten    varchar(80)    No          
context    varchar(80)    No          
channame    varchar(80)    No          
src    varchar(80)    No          
dst    varchar(80)    No          
channel    varchar(80)    No          
dstchannel    varchar(80)    No          
appname    varchar(80)    No          
appdata    varchar(80)    No          
amaflags    int(11)    No          
accountcode    varchar(20)    No          
uniqueid    varchar(32)    No          
linkedid    varchar(32)    No          
peer    varchar(80)    No          
userdeftype    varchar(255)    No          
eventextra    varchar(255)    No          
userfield    varchar(255)    No          
Indexes: Documentation

Keyname    Type    Unique    Packed    Column    Cardinality    Collation    Null    Comment
PRIMARY    BTREE    Yes    No    id    0    A      
uniqueid_index    BTREE    No    No    uniqueid    0    A      
linkedid_index    BTREE    No    No    linkedid    0    A      


Space usage:
Type    Usage
Data    0    B
Index    1,024    B
Total    1,024    B
     Row Statistics:
Statements    Value
Format    dynamic
Rows    0
Next Autoindex    1
Creation    Jul 06, 2015 at 09:48 AM
Last update    Jul 06, 2015 at 09:48 AM
 

wardmundy

Nerd Uno
Joined
Oct 12, 2007
Messages
15,231
Reaction score
2,666
Typical CDR report entry in FreePBX 12 looks like this:

But then you can click on the System entry (uniqueid => linkedid) for the CEL detail:
 

Sylvain Boily

Active Member
Joined
Apr 30, 2016
Messages
259
Reaction score
144
Location
Quebec
There is already a CEL table on XiVO. We generate on CDR with this table and events from our bus because originally the CDR on asterisk was broken on some scenario. We are not return with Asterisk 13 with the default CDR modules because we always have some problems with external transfer.

What is the most important informations you need to have on CDR. Do you really need lastapp or lastdata ?
 

Members online

PIAF 5 - Powered by 3CX

Forum statistics

Threads
22,446
Messages
137,997
Members
14,613
Latest member
roshan2019