Exporting Monitoring Data

Scenarios

If you want to analyze the usage of your edge site to locate faults, you can export CloudPond monitoring data.

Procedure

1. Log in to the management console.
2. Click in the upper left corner to select a region.
3. Click to display Service List. Under Management & Governance, select Cloud Eye.
4. In the navigation pane on the left, choose Cloud Service Monitoring > CloudPond.
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 file in .csv format.

   • The first row in the exported monitoring report displays the user name, 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 the .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.

        For example, to convert a Unix timestamp of 1475918112000 to Shanghai time (UTC+8), use the formula from step b: 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.