How do I list all Amazon RDS DB Instance Classes for DB engine oracle-ee using AWS CLI -


i trying list db instance class in format this:

db.t1.micro db.m1.small db.m1.medium db.m1.large db.m1.xlarge db.m2.xlarge db.m2.2xlarge db.m2.4xlarge db.m3.medium db.m3.large db.m3.xlarge db.m3.2xlarge db.m4.large db.m4.xlarge db.m4.2xlarge db.m4.4xlarge db.m4.10xlarge db.r3.large db.r3.xlarge db.r3.2xlarge db.r3.4xlarge db.r3.8xlarge db.t2.micro db.t2.small db.t2.medium db.t2.large.

there command list of db instance types can find way --query it.

aws rds describe-orderable-db-instance-options  --engine oracle-ee --engine-version 12.1.0.2.v8 --license-model bring-your-own-license --output table 

output of command huge , can't sort out.

this command:

aws rds describe-orderable-db-instance-options  --engine oracle-ee --engine-version 12.1.0.2.v8 --license-model bring-your-own-license --query orderabledbinstanceoptions[*].dbinstanceclass --output text 

outputs:

db.m1.large db.m1.large db.m1.large db.m1.medium    db.m1.medium db.m1.medium    db.m1.small db.m1.small db.m1.small db.m1.xlarge db.m1.xlarge    db.m1.xlarge    db.m2.2xlarge   db.m2.2xlarge db.m2.2xlarge   db.m2.4xlarge   db.m2.4xlarge   db.m2.4xlarge    etc 

however, there duplicates due multiple licensing options. de-duplicated version be:

aws rds describe-orderable-db-instance-options  --engine oracle-ee --engine-version 12.1.0.2.v8 --license-model bring-your-own-license --query orderabledbinstanceoptions[*].dbinstanceclass --output text | sed -e 'y/\t/\n/' | uniq 

outputs:

db.m1.large db.m1.medium db.m1.small db.m1.xlarge db.m2.2xlarge db.m2.4xlarge etc 

Comments

Popular posts from this blog

javascript - Create a stacked percentage column -

Optimising Firebase database by automatically overwriting data -

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -