Copy Agent Status history to another database

[Marco pbx]

Hi all!
I am trying to copy the agent status history to another database, like Postgres. I will use this for my custom report purposes in our call centre.

I already have the integration for copying the CDR output table every 15 minutes from 3CX to Postgres, but this integration does not have the login history information.

How can i get this data from Hosted 3CX?



Thanks!

 

[VoIPTools]

Take a look at our 3CX Exporter tool. We replicate this data on a scheduled basis (default every 60 seconds). Note that we currently support SQL Server, MySQL, and Maria DB as destinations, but now with the 3CX Grafana interface, perhaps it is time to add PostgreSQL to our list.



Here is some sample SQL Server data from Exporter:

 

[Marco pbx]

I found a tricky solution and wanted to share. I created a scheduled report of the login history for yesterday and started scraping the CSV email attachment automatically every day when a new email arrives in my inbox every morning which is sent by 3CX.

After scraping the data, I insert it as rows into my PostgreSQL table and connect to a frontend to query these records visually.

 

[VoIPTools]

You may also want to take a look at our 3cx exporter tool which can replicate all the 3CX tables automatically (default every 60 seconds).