We can export/download any data from Reports screen in Applicare Console.
[Screenshot 1 is not available on this page.]
Few reports may not support CSV format. In that case we can export data into CSV format using MySQL Workbench if Applicare is using MySQL database as its datastore.
Go to MySQL Workbench and connect applicare database. Right click on the table you want to export the data and select Table Data Export Wizard.
[Screenshot 2 is not available on this page.]
In the Table Data Export wizard, select the columns you want to export and click on Next.
[Screenshot 3 is not available on this page.]
Now, select the file path and format, then click on Next.
[Screenshot 4 is not available on this page.]
Finally, click on Next to complete the export.
[Screenshot 5 is not available on this page.]
We can also export data from specific SQLs to csv files. In this example below we are going to export EUM Realtime Transactions data using the following SQL
SELECT u.url, e.recorded, e.total_time, e.rendering_time, e.resp_time, e.server, e.ip, e.browser, e.os, e.country_code, e.region, e.dom_download_time, e.dom_process_time, e.serv_conn_time, e.resp_available_time, e.dom_ready_time, e.resource_fetch_time FROM eum_entry e JOIN eum_url u ON e.page_id = u.id WHERE recorded BETWEEN '2023-05-31 00:00:00' AND '2023-06-26 00:00:00' ORDER BY recorded DESC
We run this SQL in Workbench
[Screenshot 6 is not available on this page.]
and export the results to csv
[Screenshot 7 is not available on this page.]
and you can open the csv file in any editor or import to Excel.
[Screenshot 8 is not available on this page.]