AdvisorExtracting datapoints via API
Using a report worked for me. I create 3 different Resource Metric Trend reports for CPU, RAM, disk utilisation. Scheduled them to run daily to generate a CSV report. I've got about 600 servers in there at the moment, so was a few thousand rows in the Volumes report, which seems to run fine as a scheduled report and only seems to take a minute or two to run.
I have my script call the /report/links/{reportId} endpoint, then download the most recent CSV and process that data. This is far quicker than iterating through all the API calls needed to gather the data.
The most granular you can go is 2 hours of data, so I'm able to get the average for each data point over the 2 hours before the report was run.
Report frequency is 1 day at the most, but I found that I could reschedule the report from the API as well. So, if I have the script run just after the report, it could get the average for the last 2 hours then the script can reschedule the report to run again in 2 hours.
