Can I Filter By Status on RDS Reserved Instances page

0

On the RDS "Reserved Instance" page I have hundreds of Reserved Instances from multiple years of reservations. I'd like to filter by Status = Active so that I can see only reservations that are currently active. Once filtered, I'd be able to sort by any of the columns using the column headers.

I can currently sort by Status, and have Active instances at the top, but then I can't further sort by other columns

1 Answer
0

Unfortunately, the RDS Reserved Instances page in the AWS Management Console does not currently offer a direct filter option for the Status column. This means you cannot easily filter to show only Active reservations.

As you've noted, you can sort by the Status column to bring Active instances to the top, but this prevents further sorting by other columns, which limits the ability to organize and analyze your active reservations effectively.

To work around this limitation, you have a few options:

  1. Use the AWS CLI: You can use the 'aws rds describe-reserved-db-instances' command to retrieve information about your Reserved Instances. This allows you to filter and sort the data programmatically, giving you more flexibility in how you view your active reservations.

  2. Export and manipulate data: You could export the data from the RDS Reserved Instances page (if such an option is available) and then use a spreadsheet application to filter and sort as needed.

  3. AWS Cost Explorer: This tool allows you to analyze your Reserved Instance usage and coverage. While it's not the same as viewing the reservations directly, it can provide valuable insights into your active reservations.

  4. AWS Cost and Usage Report: This detailed report can be configured to include information about your Reserved Instances, which you can then analyze using your preferred data analysis tools.

If the ability to filter by Status is crucial for your workflow, you may want to submit a feature request to AWS. They often take customer feedback into account when improving their services.
Sources
Understanding your reservation line items - AWS Data Exports
DescribeReservedInstancesListings - Amazon Elastic Compute Cloud

profile picture
answered 2 months ago
profile picture
EXPERT
reviewed 2 months ago
  • Correct, so this is effectively a minor feature request

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions