Lab 3.2: Generate Reports in CSV using the API

Note

Estimated time to complete: 5 minutes

Lab environment access

If you have not yet visited the page Getting Started, please do so.

Tasks

  1. From the lab environment, launch a remote desktop session to have access to the Ubuntu Desktop.

  2. Open a terminal and execute the following script to export the analytics of site16_boston into a CSV:

    cd f5-demo-bigiq-analytics-export-restapi
./export_app_http_stats_csv_demo.sh /security/site16_boston/serviceMain -1h now 60 -1h now 60
../../_images/img_lab2_1.png

The script is getting the Analytics using BIG-IQ API and exports it to a JSON file. Then, the JSON output is converted to a CSV file using a json2csv tool.

../../_images/img_lab2_2.png
  1. Navigate in the f5-demo-bigiq-analytics-export-restapi folder and open the output.csv file.
../../_images/img_lab2_3.png

The data exported correspond to the HTTP Transactions for site16_boston application services.

../../_images/img_lab2_4.png