Help Center/ Cloud Eye/ FAQs/ General Consulting/ How Can I Export Collected Data?
Updated on 2024-01-11 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. Configure the time range, period, resource type, dimension, monitored object, and metric.
  4. Click Export.

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

  • The first row in the exported monitoring report 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 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: General Consulting