Skip to content

Instantly share code, notes, and snippets.

@vjanelle
Last active May 25, 2016 06:29
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 vjanelle/a6cdb12b352eb5201a481813605f865b to your computer and use it in GitHub Desktop.
Save vjanelle/a6cdb12b352eb5201a481813605f865b to your computer and use it in GitHub Desktop.
#!/usr/bin/env python
import boto3
config = {}
config['region'] = 'us-west-2'
rds = boto3.client('rds', region_name=config['region'])
ec2 = boto3.resource('ec2', region_name=config['region'])
def main():
global rds, iam, ec2
_identifiers = []
_instances = []
region = config['region']
paginator = rds.get_paginator('describe_db_instances')
for instances in paginator.paginate(PaginationConfig={"PageSize": 100}):
for instance in instances['DBInstances']:
security_group_id = instance['VpcSecurityGroups'][0]['VpcSecurityGroupId']
account_id = ec2.SecurityGroup(security_group_id).owner_id
identifier = instance['DBInstanceIdentifier']
arn = "arn:aws:rds:%(region)s:%(account_id)s:db:%(identifier)s" % locals()
tags = rds.list_tags_for_resource(ResourceName=arn)['TagList']
print "Instance: %s, tags: %s" % ( identifier, tags )
if __name__ == "__main__":
main()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment