Custom Wallboard - Get queue realtime statistics

[jhonku]

HI,
I am developing custom wallboard with specific call center metrics like SLA and real number of busy agents.
I get queue waiting calls using GetActiveConnections() method from API. Also, I get queue configuration using DNProperty class (SLA value).

I am trying to calculate other queue statistics but probably is easier to get them using an existing API method for that. I found Statistics Class but I am not sure if it is what I need and how to use it.
Can I get real time queue statistics from any API method? Wallboard information must be store in some place or variables, but I couldn't find them yet.

Any help is appreciate

 

[edossantos]

No, that information is not available through any API.

 

[jhonku]

Thanks Ernesto,
If there isn't an API for that, Is there any table in Database where this information is saved?
If it is possible to reset queue statistics periodically, it means that this data is stored in some place

 

[edossantos]

The way in which this works is not documented. Probably the database has this information, but accessing it is not recommended, and the database structure is not documented, so you're on your own here. Please note that if you base your solution in accessing the 3CX database, any 3CX update might break it, as we could make any change to the database structure without further notice.

 

[VoIPTools]

As Ernesto stressed, accessing the PostgreSQL database directly is strenuously discouraged by 3CX support. If you are not very careful about "HOW" you connect to the database, you could inadvertently lock records / tables and that would be bad. Further, you need to ensure it is a read-only connection. Usually, I would push you toward the CDR files, but queue statistics are not in the CDR files. The table you are looking for is: callcent_queuecalls

If you want a safe (but still unsupported) way of accessing this table's data, you might want to look at our 3CX Exporter add-on. It's been in use around the world for around 8 years with no reported issues.