On the CES dashboard page, choose Instance Monitoring and click Export Monitoring Data. Select Service, Dimension, Monitored Object, and Metric as prompted. Click Export.
- The first row of the report indicates the metric collection time expressed in Unix timestamp, and the second row indicates the metric data.
- If you need to convert the time in Unix timestamp to the time of the target time zone, perform the following steps:
- Use Excel to open a .csv file.
- Use the following formula to convert the time:
Target time = (Unix timestamp/1000 + (Target time zone) x 3600)/86400 + 70 x 365 + 19
- Set the cell format to Date.
For example, the Unix timestamp is 1475918112000 and the target time is Beijing time. Beijing is located in the UTC+8 time zone. Therefore, the target time is calculated as follows:
Target time = (1475918112000/1000 + (+8) x 3600)/86400 + 70 x 365 + 19
Set the cell format to date and select such format as 2016/3/14 13:30. Then, the final time is obtained, that is 2016/10/8 17:15.