3CX Database structure

[aleksey.zhirenkov]

I spent a lot of time trying to find a schema of database and finally have generated one myself with strong help of DataGrip application.
One can use it and start doing your own things
Check out the attach file and reach me out in facebook\linkedin if you need assistance.

My version is 15.5.

Lately I will provide some queries examples, when I will figure it out.

 

[YiannisH_3CX]

Please note that accessing the 3CX database or manual intervention to it will void all support so if you face any issues 3CX support will not be able to assist you. Changes to the Database can result to system instability and general system failure so i would not recommend performing any changes.

 

[aleksey.zhirenkov]

Get the users/operators details:

SELECT
    u.firstname
    ,u.lastname
    ,e.idextension                as id_extension
    ,e.authid                    as phone_internal
    ,e.outcid                    as phone_public
FROM extension e
INNER JOIN dn ON dn.iddn = e.fkiddn
INNER JOIN users u ON u.fkidextension = e.idextension;

 

[russelltown]

Would love to see queries to give us the number of agents logged in to a queue, and the waiting time of the oldest call in the queue.

The builtin 3CX dashboard is lacking these (which are fairly standard in just about every other phone system wallboard)