Help Center/ Cloud Eye/ User Guide (Paris Region) / FAQs/ Product Consultation/ How Can I Export Collected Data?
Updated on 2022-02-22 GMT+08:00
View PDF
Share

How Can I Export Collected Data?

  1. On the Cloud Eye console, choose Cloud Service Monitoring or Server Monitoring.
  2. Click Export Data.
  3. Set the time range, resource type, dimension, monitored object, and metric.
  4. Click Export.
  • The first row in the exported monitoring report displays the username, region, service, instance name, instance ID, metric name, metric data, time, and timestamp.
  • 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 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.

Parent topic: Product Consultation