Skip to content

AWS:RDS:List all DBs by CA Certificate

lbonanomi edited this page Jul 6, 2024 · 4 revisions
account=$(aws iam list-account-aliases | jq -r '.AccountAliases.[]' ); 
regions | while read r; 
do 
    aws rds describe-db-instances --region=$r 2>/dev/null |\  
    jq -r '.DBInstances[] | ( [ .DBInstanceIdentifier , .Engine , .AvailabilityZone , .CACertificateIdentifier ] | @csv )' |\ 
    awk '{ print "'$account','$r',"$0 }'; 
done

Clone this wiki locally