V20 U6 Final - All Improved Reporting

[OrloOneGM]

Can we get a built-in trunk utilisation report. I suspect we have some clients that have more sessions than they need, and they could be saving money on a per month basis.

 

[KyriacosS_3CX]

Hi @diplodock ,

You should be able to follow the guides found in this blog:
https://www.3cx.com/blog/releases/grafana-reporting/

 

[JamieR]

Epic work all.

Are there any plans to provide more flexibility around the offload interval? I have a customer who is not happy that their boards will only update every hour - ideally needs to be every minute or perhaps 5. They'd like up to date data at all times.

In addition, are there any plans to revive the functionality of v18 where email reports had their own individual schedule rather than there being a system wide setting for all reports?

I understand the potential reason for restricting these (performance overheads) but for self hosted folks with a lot of CPU resource available, can't see far more frequent offload / generation being an issue?

 

[Dragan Djurdjevic]

Which google account shoud I need for integration 3cx and google? According documentation we need Google Workspace accound with admin privilage which is not free. I can not get anz data in grafana without 3cx integration with google

 

[KyriacosS_3CX]

Which google account shoud I need for integration 3cx and google? According documentation we need Google Workspace accound with admin privilage which is not free. I can not get anz data in grafana without 3cx integration with google

Hello,

BigQuery has a Free Tier that could be sufficient for a lot of cases.
You can find more info here: https://cloud.google.com/free/docs/free-cloud-features?authuser=1&hl=en#free-tier-usage-limits

You should be able to set up a Workspace Account with minimal cost.

You can always host a PostgreSQL database on your own systems which is free.

Best,
KS.

 

[mschnieder]

In version 20.0 Update 6 (Build 724 Release), querying the API endpoint CallHistoryView is no longer possible.
All calls made since the update are no longer accessible via the API endpoint.
Is there a new endpoint for this, or is this a bug?

Called Endpoint: /xapi/v1/CallHistoryView

 

[diplodock]

Hi @diplodock ,

You should be able to follow the guides found in this blog:
https://www.3cx.com/blog/releases/grafana-reporting/

Can't find in this post anything about qeue stat.
Can you describe, what you mean?

 

[diplodock]

Hi

We can exchange SQL or dashboards so you can have it working before we release. How does that sound?

I'm really looking forward to this! dashboards for qeue

 

[Dragan Djurdjevic]

Dear all,

I have comppleted integration 3cx and PostgreSQL using following link: https://www.3cx.com/docs/postgresql-configuration/
Connection is fine. Where can I find 3CX dashboards for Grafana via PostgreSQL?

 

[KoesioOccitanieTech]

Dear all,

I have comppleted integration 3cx and PostgreSQL using following link: https://www.3cx.com/docs/postgresql-configuration/
Connection is fine. Where can I find 3CX dashboards for Grafana via PostgreSQL?

Hi

I'm really looking forward to this! dashboards for qeue

You can get it here (RC3 news) : https://www.3cx.com/blog/releases/u6-grafana-visuals-update/

Configure 3CX Offload storage inside 3CX > Integrations > Data Connectors, then Select Database

1. If you offload to Google BigQuery download this Google BigQuery Dashboard Package
2. If you offload to a PostgreSQL server download this PostgreSQL Dashboard Package

 

[Dragan Djurdjevic]

You can get it here (RC3 news) : https://www.3cx.com/blog/releases/u6-grafana-visuals-update/

Configure 3CX Offload storage inside 3CX > Integrations > Data Connectors, then Select Database

1. If you offload to Google BigQuery download this Google BigQuery Dashboard Package
2. If you offload to a PostgreSQL server download this PostgreSQL Dashboard Package

Thank you very much

 

[Dragan Djurdjevic]

Can we use standalone Grafana in Linux instead of Cloud Grafana for 3cx reporting?

 

[Evolute IT]

Can we use standalone Grafana in Linux instead of Cloud Grafana for 3cx reporting?

Yes

 

[diplodock]

Dear @diplodock Great question.
You are correct to wonder. And yes, you are perfectly right.
We made it for Queue callbacks only for now as a first step.
But we are expanding the query to also catch calls which were made outside of the queue callback functionality.

What datasource are you using? We can exchange SQL or dashboards so you can have it working before we release. How does that sound?

Thanks for reporting.

I use postgreSQL+grafana for reporting.Need to try this feature! How can I do this? !!!

 

[Dragan Djurdjevic]

Yes

OK. Thank you.

I have noticed that Grafana on premise free edition has no export plugin.
For pdf exporter function we need enterprise edition which is not free.

 

[SweetAction]

OK. Thank you.

I have noticed that Grafana on premise free edition has no export plugin.
For pdf exporter function we need enterprise edition which is not free.

Would this work? https://github.com/arthur-mdn/ExportGrafanaDashboardToPDF

 

[nikolascx]

I use postgreSQL+grafana for reporting.Need to try this feature! How can I do this? !!!

Hi @diplodock
Import this dashboard and let us know what you think ;-)
Thanks for your feedback

 

[diplodock]

Hi @diplodock
Import this dashboard and let us know what you think ;-)
Thanks for your feedback

Sorry, can't see any file or link. Where i can take dashboard for import?

 

[nikolascx]

Sent you link in pm.

 

[pa_an_br]

One feature I really need is being able to set the internal number that shows to other users so we can present group numbers. Its the biggest bug bear as staff then ring the number from the missed call but that person could be out or away from their desk. This helps with departments that call when working from home.

Any chance of that being added?