forked from docs/doc-exports
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Youyuan, Pan <panyouyuan@huawei.com> Co-committed-by: Youyuan, Pan <panyouyuan@huawei.com>
2.6 KiB
2.6 KiB
How Can I Export Collected Data?
- On the Cloud Eye console, choose Cloud Service Monitoring or Server Monitoring.
- Click Export Data.
- Configure the time range, resource type, dimension, monitored object, and metric.
- 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. 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:
- 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 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