pull old RDS snapshot info and create csv files per region

old-rds-snapshots-to-csv.py

from asyncore import write
import boto3
import datetime
import pytz
import csv

regions = ['us-east-1','eu-central-1','eu-west-1','ca-central-1','us-east-2','eu-west-2','us-west-1','ap-southeast-2','ap-southeast-1','us-west-2']
headers = ['DBSnapshotIdentifier', 'DBInstanceIdentifier', 'SnapshotCreateTime', 'AllocatedStorage', 'DBSnapshotArn']

now = pytz.utc.localize(datetime.datetime.now())

for region in regions:
    rds = boto3.client("rds", region)
    with open(region + '_old_snapshots_2022.csv', 'w', encoding='UTF8') as f:
        writer = csv.writer(f)
        writer.writerow(headers)

        for snapshot in rds.describe_db_snapshots()['DBSnapshots']:
            # print(snapshot)
            if snapshot['SnapshotCreateTime'] < now - datetime.timedelta(days=365):
                row = []
                for item in headers:
                    row.append(snapshot[item])
                writer.writerow(row)