2

How can I extract the historical metrics data from aws cloudwatch and generate monthly report on the instance health check? I'm looking for free tools that can be used.

If I subscripe to detail AWS cloudwatch, will I be able to export the matrices historical data to eg excel?

Appreciate your help! Su

Suguna
  • 23
  • 4

2 Answers2

0

Check this answer AWS Cloudwatch Log - Is that possible to export existing log data from it?

Excel is not one of the supported format but full cloudwatch information is available as text and you should be able to export it for further processing

Otherwise, you can see Cloudwatch to ElasticSearch option

qkhanhpro
  • 4,371
  • 2
  • 33
  • 45
  • Does cloudwatch logs capture the Ram, cpu utilisation and bandwidth of the instances? – Suguna May 06 '19 at 00:50
  • Ram usage is not captures by default – qkhanhpro May 07 '19 at 11:38
  • How can I configure to capture the Ram usage? – Suguna May 08 '19 at 08:21
  • You will need to install a software - the Cloudwatch Agent on your machine https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/metrics-collected-by-CloudWatch-agent.html By default AWS manage the CPU Util and Network In / Out but not RAM usage – qkhanhpro May 08 '19 at 08:28
0

because the monthly report is a routine work, you can try categraf cloudwatch plugin . It can easily export cloud-watch metrics to your Prometheus then you can visualize data using grafana and export to csv.

And further more, you can also try nightingale project which can be an alternative of prometheus&grafana.

vicla
  • 1
  • 2