In Static/ODBC mode, which is the recommended mode of work, PBXware uses
MySQL 4.0 for database.

To access that database:

cd /home/servers/sitemanager

sh/mysql --password=$(cat sh/lib/mysql)

When inside,

show databases;

the command will show several databases, among which you will have
pbxware_xxx databases, where xxx are the numbers of your tenant prefix.
So, if you have 5 tenants you will have 5 pbxware_xxxx tables.

Let's say that you have a tenant with prefix 100.

use pbxware_100;

will use that tenant's database.

Now: show tables will show all the tables in this database. CDRs
database is named "cdr".

If you type: show fields from cdr;
you will get list of fields which are pretty self explanatory but here

http://www.voip-info.org/wiki/view/Asterisk+billing


you have most of the fields explained. The ones that are not:


tenant - tenant on which the call was made

billamount - how much the call was billed

accountcode - the extension which is making call and can be different
from src field

userfield - extension which received a call and can be diferrent then
dst field. in userfield sometimes you could have recording if queue
agents are in question


uniqueid - is a link to recording which is essentially a timestamp when
the call was recorded.