Querying Background Tables?

[dommy575]

Afternoon All

Im wondering if its possible to query the background tables of 3cx to gain information of agent ID's / Extensions? Ideally id like to know how long agents have spent in Do not disturb / Lunch etc etc

My question is - is this actually possible?

Many thanks in advance

Dom

 

[Evolute IT]

@VoIPTools has something built for this.

You should NOT access the database directly.

 

[dommy575]

@VoIPTools has something built for this.

You should NOT access the database directly.

Hi - thanks for the reply - i have used Aspect and Avaya phone systems where we were given access to back ground static and dynamic tables in order to query on our own reporting MI teams, are you saying this isnt available on this platform?

 

[Evolute IT]

Hi - thanks for the reply - i have used Aspect and Avaya phone systems where we were given access to back ground static and dynamic tables in order to query on our own reporting MI teams, are you saying this isnt available on this platform?

The database is not to be touched as you could brick something or create problems. Support is void if you access the database directly.

You should use the Data Connectors to export CDR and system health, and use Call Control (VoIPTools did the hard work already) to track changes and store them yourself.

 

[dommy575]

The database is not to be touched as you could brick something or create problems. Support is void if you access the database directly.

You should use the Data Connectors to export CDR and system health, and use Call Control (VoIPTools did the hard work already) to track changes and store them yourself.

ok - thanks for the answer

 

[VoIPTools]

3CX does not track when a user changes their presence status, so even if you had access to the database, the information does not exist. But, we do track presence changes in our 3CX Competitive Wallboard, and 3CX Custom Presence tools. We are getting ready to release a new 3CX Report Builder tool that will have reports/charts you can customize specifically designed to give you visibility into how staff are using presence in 3CX.