Exporting Monitoring Data

Scenarios

If you want to collect EIP traffic statistics within a specified period or analyze the bandwidth or traffic usage of EIPs to locate faults, you can export EIP monitoring data.

Procedure

1. Log in to the management console.

2. Click in the upper left corner and select the desired region and project.
3. Hover on the upper left corner to display Service List and choose Management & Governance > Cloud Eye.
4. In the navigation pane on the left, choose Cloud Service Monitoring > Elastic IP and Bandwidth.
5. On the Cloud Service Monitoring page, click Export Data.
6. Configure the time range, period, resource type, dimension, monitored object, and metric.
7. Click Export.

You can export data for multiple metrics at a time to a CSV file.

• The first row in the exported CSV file displays the username, region, service, instance name, instance ID, metric name, metric data, time, and timestamp. You can view historical monitoring data.
• To convert the time using a Unix timestamp to the time of the target time zone, perform the following steps:
  1. Use Excel to open a .csv file.
  2. Use the following formula to convert the time:

     Target time = [Unix timestamp/1000 + (Target time zone) x 3600]/86400 + 70 x 365 + 19

  3. Set cell format to Date.

  To convert a Unix timestamp of 1475918112000 to Shanghai time (UTC+8), using the following formula:

  Target time = [1475918112000/1000 + (+8) x 3600]/86400 + 70 x 365 + 19

  Set the cell format to date and select a presentation format such as 2016/3/14 13:30. Then, the target time obtained will be presented as 2016/10/8 17:15.