Update 6 BETA - Grafana Reporting Is Finally Here!

[N_G]

Sync with Google BigQuery and leverage Grafana for powerful reporting.​

Version 20 Update 6 BETA heralds a major step forward in call reporting. Building upon the new reports recently introduced, you can now sync 3CX with Google BigQuery and leverage Grafana for all kinds of reporting, dashboarding and visualisation capabilities...

Continue reading the Original Blog Post.

 

[Evolute IT]

Couple questions!

1. Are there plans to support other connectors? Maybe like MySQL, Azure/AWS DynamoDB, etc.? Honestly, even a webhook or something that can send data in batch to custom collectors.

2. Can we get an export that is realtime or every 15min? I know it will increase load but for some big customers with big servers, they won't care and will want the fastest data we can get.

 

[PhoneMan123]

Any chance NFR licenses can be allowed to setup the database integrations? I don't want to update any of our production systems to the Beta but my NFR/demo is only a 4SC.

 

[Evolute IT]

Any chance NFR licenses can be allowed to setup the database integrations? I don't want to update any of our production systems to the Beta but my NFR/demo is only a 4SC.

Agreed, that was my next question lol Wanted to try it in our lab.

 

[Tony_Lin]

Awesome update!
It seems that Grafana's template can only be applied to Google BigQuery, and the data source cannot be selected as PostgreSQL.

 

[N_G]

@ConceptsWeb Amazon we will definitely also support.. The rest we will see. Same with interval, we will get experience with it in production first. Processor power is not the solution to everything.....

@PhoneMan123 You will have to use your primary NFR to test it.....

@Tony_Lin it probably requires some small modification but we do not have a lot of experience with Grafana templates yet

 

[Tony_Lin]

I used AI to convert a template file, and now it can work with a PostgreSQL data source.

 

[N_G]

Thank you Tony that's great

 

[KoesioOccitanieTech]

Hi,

Really nice update, can't wait to test that.

I have a question about this tiny line :
User Operation rights extended to include viewing and changing another user’s call forwarding settings.

Can we have more details about this ? Did the 3CX role table is already update ? https://www.3cx.com/docs/manual/access-roles/

Thank you.

 

[NicholasP_3CX]

Hi,

Really nice update, can't wait to test that.

I have a question about this tiny line :
User Operation rights extended to include viewing and changing another user’s call forwarding settings.

Can we have more details about this ? Did the 3CX role table is already update ? https://www.3cx.com/docs/manual/access-roles/

Thank you.

The access roles table will reflect the default settings for each of the roles. The View tab of the user allows you to tweak this, so this might not be shown in the access roles table.

 

[KoesioOccitanieTech]

The access roles table will reflect the default settings for each of the roles. The View tab of the user allows you to tweak this, so this might not be shown in the access roles table.

oh hugeeee ! I didn't check the view tab. Thank you for your reply.

 

[N_G]

The idea is that a receptionist or supervisor can change the forwarding settings or see where a call is being forwarded. it requires the V20 softphone. It could be that softphone does not support it as yet but its a matter of a week or so

 

[nikolascx]

Couple questions!

1. Are there plans to support other connectors? Maybe like MySQL, Azure/AWS DynamoDB, etc.? Honestly, even a webhook or something that can send data in batch to custom collectors.

2. Can we get an export that is realtime or every 15min? I know it will increase load but for some big customers with big servers, they won't care and will want the fastest data we can get.

@ConceptsWeb
We're leaning toward using built-in solutions from each major cloud provider, depending on demand.
Please share your current cloud setup so we can better decide which integrations to focus on.

On the AWS side:

• DynamoDB is serverless and NoSQL, while PostgreSQL is a relational SQL database. Supporting DynamoDB would involve extra work—converting SQL tables to partition-keyed JSON and uploading them. It’s doable with a few lines of code, but we’re not sure yet if it should be included.
• Amazon RDS and Aurora are better suited for direct support due to their relational nature.
• AWS also offers Database Migration Service (DMS), which can replicate data from PostgreSQL to AWS targets like DynamoDB or S3 in real time. You could use this to migrate call logs and connect them to a 3CX wallboard.

Thanks for your feedback!

 

[nikolascx]

Any chance NFR licenses can be allowed to setup the database integrations? I don't want to update any of our production systems to the Beta but my NFR/demo is only a 4SC.

Unfortunately no. But the solution is working great.. So it will not remain in Beta for so long..
In the meantime, instead of rushing to upgrade, I would prefer you list what Cloud services you use because I need to start to prepare a list of potential suggestions where and to what solution data should be offloaded.

 

[nikolascx]

Awesome update!
It seems that Grafana's template can only be applied to Google BigQuery, and the data source cannot be selected as PostgreSQL.

Assuming you added the postgress plugin and configured it, then you will be able to toggle the datasource to use postgress.


@Tony_Lin

And this will be the start of a dashboard which will have a bunch of visuals on one datasource, and other on another datasource.
This will be the answer to monitor data from multiple pbx's (You can have multiple Postgress Datasources, but if each is configured to a different pbx, then they are all different)

If you cannot, then it is a Grafana rights issue. You need to check this. The template does not hardcode the datasource. So you should be able to change it whenever you want.

 

[nikolascx]

I used AI to convert a template file, and now it can work with a PostgreSQL data source.

Additional note on this..

For now these dashboards are for BigQuery. So if you want to change to another data source, it should be another Big Query Data source (configured for another pbx)

Do you see data? I doubt you will see data. I will explain

These are the first dashboards so they are based on BigQuery.
We wanted to be able to share these templates, and force Grafana to prompt you to map a data source.
This allows the dashboard to be portable across different environments or setups where the plugin name may differ.

We are not yet 100% sure that having one dashboard for all is actually possible. Whilst bigquery and postgres are both SQL Based and indeed both share a lot of similar syntax, there are differences in functions, data types and SQL dialects.

I expect that the visuals using simple SQL will work on both. But some others will not work.

For now, this is to be used only against Bigquery.. Postgres templates are coming very very soon.

Thanks for your updates.

 

[PhoneMan123]

Unfortunately no. But the solution is working great.. So it will not remain in Beta for so long..
In the meantime, instead of rushing to upgrade, I would prefer you list what Cloud services you use because I need to start to prepare a list of potential suggestions where and to what solution data should be offloaded.

All of our clients are in AWS so we would look to use a solution supported there.

Also FYI the Info Tip for "See Presence" and "Barge-in,Listen,& Whisper" both list the same information:

 

[nikolascx]

All of our clients are in AWS so we would look to use a solution supported there.

Also FYI the Info Tip for "See Presence" and "Barge-in,Listen,& Whisper" both list the same information:

View attachment 47529


View attachment 47530

@PhoneMan123
What service exactly in AWS do you use? Redshift, Aurora, RDS?

 

[Evolute IT]

@ConceptsWeb
We're leaning toward using built-in solutions from each major cloud provider, depending on demand.
Please share your current cloud setup so we can better decide which integrations to focus on.

On the AWS side:

• DynamoDB is serverless and NoSQL, while PostgreSQL is a relational SQL database. Supporting DynamoDB would involve extra work—converting SQL tables to partition-keyed JSON and uploading them. It’s doable with a few lines of code, but we’re not sure yet if it should be included.
• Amazon RDS and Aurora are better suited for direct support due to their relational nature.
• AWS also offers Database Migration Service (DMS), which can replicate data from PostgreSQL to AWS targets like DynamoDB or S3 in real time. You could use this to migrate call logs and connect them to a 3CX wallboard.

Thanks for your feedback!

I would say AWS Aurora would work. Another one is Azure Data Lake, which can be connected to BI as well.

One little note on Google BigQuery. I was expecting it to use the JSON key from the storage section, and prompt us to simply enable the API and create a table, but it seems it requires Google Workspace, which we don't use, but I'd still like to be able to use those Google stuff.

 

[PhoneMan123]

@PhoneMan123
What service exactly in AWS do you use? Redshift, Aurora, RDS?

Sorry currently not doing anything but hosting the PBX there. We would like to add any additional needed services for reporting to AWS to keep it all in one place for billing and tracking.