Hey everyone! I'm diving into some Cost and Usage Reports (CUR 2.0) and trying to replicate the Savings Plans Coverage and Reserved Instance Coverage reports. I'm specifically looking for help on two calculations. First, I need to figure out the total on-demand equivalent cost that can be covered by Savings Plans (this is referred to as "total_cost" in the SP Coverage report). Second, I'm trying to determine the total running hours that can be covered by Reserved Instances (known as "total_running_hours" in the RI Coverage report). These metrics will help me analyze how much on-demand usage is already covered versus what's not. I've managed to get most of the other data I need, but I'm hitting a wall with these two. If anyone has a SQL query or some guidance, I'd love to hear it. Thanks!
3 Answers
You might want to check out the AWS CUR Query Library. They have specific queries for RI coverage and possibly even for Savings Plans. It's a solid resource for building your reports!
I haven't used CUR in some time, but there's actually an API call that could help with your needs. Check out the Savings Plans coverage API. Just a heads up though, it provides daily granularity, not hourly, which might be an issue for you.
Thanks, TechGuru88! I’m aware of that API, but it’s the hourly granularity I’m after, which is why I’m focused on CUR.
I remember CUR having a field for subscription ID which links to your SP or RI purchases. There’s also an OD price field for the on-demand rate you’ll need. Don’t forget to look into NURI or PURI rows for any unused RIs, as they might help in your calculations. Finding costs associated with unused savings plan commitments might be trickier, but it’s worth checking out your usage that’s covered by commitments as well.
Thanks, DataWizard42! I didn’t know about this resource, and it seems like it could be really helpful.