Skip to content

Instantly share code, notes, and snippets.

@rtrouton

rtrouton/gist:9992d2a0e28a114402861afda9530743 Secret

Created August 27, 2021 17:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rtrouton/9992d2a0e28a114402861afda9530743 to your computer and use it in GitHub Desktop.
Save rtrouton/9992d2a0e28a114402861afda9530743 to your computer and use it in GitHub Desktop.
Download ZIP
Sample code to help identify an RDS database by a specified tag key and that tag's value. In this example, with a Name tag where the Name tag's value is VIPDatabase, it would look like this.
Raw
gistfile1.txt
#!/bin/bash
TagKey="Name"
TagValue="VIPDatabase"
aws_region=$(/bin/curl -s http://169.254.169.254/latest/meta-data/placement/availability-zone | sed "s/.$//g")
RDSDatabaseARNIdentifier=$(aws --region "$aws_region" resourcegroupstaggingapi get-resources --resource-type-filters rds:db --query "ResourceTagMappingList[?Tags[? Key == '$TagKey' && Value == '$TagValue']].ResourceARN" --output=text)
RDSDatabaseDBIdentifier=$(aws rds --region "$aws_region" describe-db-instances --db-instance-identifier "$RDSDatabaseARNIdentifier" --query "*[].{DBInstanceIdentifier:DBInstanceIdentifier}" --output text)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment