Skip to content

Instantly share code, notes, and snippets.

@instaBOT

instaBOT/list-all-rds-prod-db-snapshots.sh

Created September 23, 2015 19:57
Show Gist options
  • Save instaBOT/86db005c34a5ce366454 to your computer and use it in GitHub Desktop.
Save instaBOT/86db005c34a5ce366454 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
list-all-rds-prod-db-snapshots.sh
#!/usr/bin/env bash
cd
set -e
# instagis2015: name of the RDS DB instance currently in production
aws rds describe-db-snapshots --db-instance-identifier instagis2015 \
--query 'DBSnapshots[*].[SnapshotCreateTime, DBSnapshotIdentifier, SnapshotType, Status]' \
--output table
# ---------------------------------------------------------------------------------------------
# | DescribeDBSnapshots |
# +---------------------------+-------------------------------------+------------+------------+
# | 2015-09-15T07:23:26.594Z | rds:instagis2015-2015-09-15-07-22 | automated | available |
# | 2015-09-16T07:21:47.252Z | rds:instagis2015-2015-09-16-07-21 | automated | available |
# | 2015-09-17T07:21:22.071Z | rds:instagis2015-2015-09-17-07-21 | automated | available |
# | 2015-09-18T07:21:29.627Z | rds:instagis2015-2015-09-18-07-21 | automated | available |
# | 2015-09-19T07:21:54.681Z | rds:instagis2015-2015-09-19-07-21 | automated | available |
# | 2015-09-20T07:21:34.490Z | rds:instagis2015-2015-09-20-07-21 | automated | available |
# | 2015-09-21T07:21:16.978Z | rds:instagis2015-2015-09-21-07-21 | automated | available |
# | 2015-09-22T07:22:25.738Z | rds:instagis2015-2015-09-22-07-22 | automated | available |
# | 2015-09-23T07:23:03.036Z | rds:instagis2015-2015-09-23-07-23 | automated | available |
# +---------------------------+-------------------------------------+------------+------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment