AWS CLI Command to fetch RDS Snapshot Details

aws rds describe-db-snapshots --query "DBSnapshots[?SnapshotCreateTime <= \`"$(date --date "30 days ago" +"%Y-%m-%dT%H:%M:%S.000000+00:00")"\`]"

First, install the necessary libraries for Python:

pip install python-dateutil

Create a Python script - list_old_snapshots.py

import sys
import json
import dateutil.parser
from datetime import datetime, timedelta

# Load JSON input from stdin
snapshots = json.load(sys.stdin)

# Get the date one month ago
one_month_ago = datetime.now(dateutil.tz.tzutc()) - timedelta(days=30)

# Filter snapshots older than one month
old_snapshots = [snapshot for snapshot in snapshots['DBSnapshots'] if dateutil.parser.parse(snapshot['SnapshotCreateTime']) < one_month_ago]

# Print filtered snapshots as JSON
print(json.dumps(old_snapshots, indent=2, default=str))

Now, use the following command to get the RDS snapshots older than one month:

aws rds describe-db-snapshots | python list_old_snapshots.py