Export Applicare data to csv from MySQL
We can export/download any data from Reports screen in Applicare Console.
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.
In the Table Data Export wizard, select the columns you want to export and click on Next.
Now, select the file path and format, then click on Next.
Finally, click on Next to complete the export.
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
and export the results to csv
and you can open the csv file in any editor or import to Excel.
Please sign in to leave a comment.
Comments
0 comments