July
11th,
2018
Get the full attributes of rds instances with its instancesidentifier
aws --profile=HA rds describe-db-instances --query 'DBInstances[?DBInstanceIdentifier==`evox-dev`]'
Get list of snapshots of RDS database.
aws --profile=HA rds describe-db-snapshots --db-instance-identifier evox-dev
Get list of snapshots of RDS databse but only display snapshot id and creation time with jq.
aws --profile=HA rds describe-db-snapshots --db-instance-identifier evox-dev | jq '[.DBSnapshots[] | {Snapshot_Identifier:.DBSnapshotIdentifier,Creationtime:.SnapshotCreateTime}]'
Get the LatestRestorableTime that is typically within the range of 5 min of current time.
aws --profile=HA rds describe-db-instances --query 'DBInstances[?DBInstanceIdentifier==`evox-dev`].LatestRestorableTime' --output text
➜ serkanh.github.io git:(master) aws --profile=HA rds describe-db-instances --query 'DBInstances[?DBInstanceIdentifier==`evox-dev`].LatestRestorableTime' --output text | TZ='America/New_York' date
Mon Jul 23 13:01:59 EDT 2018