labunix's blog

labunixのラボUnix

AWSで英語版Windowsインスタンスを使ってみる。

■AWSで英語版Windowsインスタンスを使ってみる。
 今回はものすごく普通にWebから、AWSコンソールでポチポチしてRemminaでRDP接続してみただけ。
 RDPで外につなげる想定の無い環境なので、それでも内から外へのFirewall開けたり色々結構面倒だった。
 結果をawscliで眺めていくだけの簡単なお仕事。

■AWSCLIコマンドをしばらく使っていなかったため、バージョンが古いと思ったらstretchとしては最新。

 jqとawscliを導入してみる。
 http://labunix.hateblo.jp/entry/20180917/1537117696

$ apt-cache show awscli | grep Filename
Filename: pool/main/a/awscli/awscli_1.11.13-1_all.deb

$ aws --version
aws-cli/1.11.13 Python/3.5.3 Linux/4.9.0-8-amd64 botocore/1.4.70

■公式サイトの情報をもとに、ホームディレクトリ以下にアップグレード(インストール)する。
 「export PATH~」はログオフ後に破棄されるので、.bashrcなどに書いておく。

 AWS Command Line Interface をインストールする
 https://docs.aws.amazon.com/ja_jp/cli/latest/userguide/cli-chap-install.html

$ python --version
Python 2.7.13

$ pip install awscli --upgrade --user
$ ~/.local/bin/aws --version
aws-cli/1.16.106 Python/2.7.13 Linux/4.9.0-8-amd64 botocore/1.12.96

$ find . -type f -name "aws"
./.local/bin/aws

$ ~/.local/bin/aws --version
aws-cli/1.16.106 Python/2.7.13 Linux/4.9.0-8-amd64 botocore/1.12.96

$ ~/.local/bin/aws configure
AWS Access Key ID [****************XXXX]: 
AWS Secret Access Key [****************XXXX]: 
Default region name [xx-xxxxx-n]: 
Default output format [json]: 

$ export PATH=~/.local/bin:$PATH
$ aws --version
aws-cli/1.16.106 Python/2.7.13 Linux/4.9.0-8-amd64 botocore/1.12.96

$ tail -1 .bashrc 
export PATH=/home/labunix/.local/bin:/usr/lib/jvm/java-7-openjdk-amd64/bin:$PATH

■せっかくなので、以下を少し改良して。。。

 awscliでAWSリージョンとAZの一覧を取得する
 http://labunix.hateblo.jp/entry/20180918/1537269823

■リージョン、AZの選択肢の確認
 リージョン名、AZ数とAZ名のカンマ区切りの一覧

$ aws ec2 describe-regions --query 'Regions[].{Name:RegionName}' --output text | sort -k 1 | \
    awk '{print "echo -n \042"$1 \
           ",\042;aws ec2 describe-availability-zones --query \047AvailabilityZones[].{Name:ZoneName}\047 --region "$1 \
           " --output text | awk \047{a=a\042,\042$0}END{print NR,a}\047"}' | sh
ap-northeast-1,3 ,ap-northeast-1a,ap-northeast-1c,ap-northeast-1d
ap-northeast-2,2 ,ap-northeast-2a,ap-northeast-2c
ap-south-1,2 ,ap-south-1a,ap-south-1b
ap-southeast-1,3 ,ap-southeast-1a,ap-southeast-1b,ap-southeast-1c
ap-southeast-2,3 ,ap-southeast-2a,ap-southeast-2b,ap-southeast-2c
ca-central-1,2 ,ca-central-1a,ca-central-1b
eu-central-1,3 ,eu-central-1a,eu-central-1b,eu-central-1c
eu-north-1,3 ,eu-north-1a,eu-north-1b,eu-north-1c
eu-west-1,3 ,eu-west-1a,eu-west-1b,eu-west-1c
eu-west-2,3 ,eu-west-2a,eu-west-2b,eu-west-2c
eu-west-3,3 ,eu-west-3a,eu-west-3b,eu-west-3c
sa-east-1,2 ,sa-east-1a,sa-east-1c
us-east-1,6 ,us-east-1a,us-east-1b,us-east-1c,us-east-1d,us-east-1e,us-east-1f
us-east-2,3 ,us-east-2a,us-east-2b,us-east-2c
us-west-1,2 ,us-west-1a,us-west-1b
us-west-2,3 ,us-west-2a,us-west-2b,us-west-2c

■AZの地理を確認する。

$ w3m -dump "https://docs.aws.amazon.com/ja_jp/AWSEC2/latest/UserGuide/using-regions-availability-zones.html" | \
    awk '/[a-z]?-[a-z]*[1-9]/&&!/に|は|が|を|に|と/' | sort -k 1
ap-northeast-1 アジアパシフィック (東京)
ap-northeast-2 アジアパシフィック (ソウル)
ap-northeast-3 アジアパシフィック (大阪: ローカル)
ap-south-1     アジアパシフィック (ムンバイ)
ap-southeast-1 アジアパシフィック (シンガポール)
ap-southeast-2 アジアパシフィック (シドニー)
ca-central-1   カナダ (中部)
eu-central-1   欧州 (フランクフルト)
eu-north-1     欧州 (ストックホルム)
eu-west-1      欧州 (アイルランド)
eu-west-2      欧州 (ロンドン)
eu-west-3      EU (パリ)
sa-east-1      南米 (サンパウロ)
us-east-1      米国東部(バージニア北部)
us-east-2      米国東部 (オハイオ)
us-west-1      米国西部 (北カリフォルニア)
us-west-2      米国西部 (オレゴン)

■AZ毎のサブネットを確認

$ aws ec2 describe-regions --query 'Regions[].{Name:RegionName}' --output text | sort -k 1 | \    
    awk '{print "aws ec2 describe-subnets --region "$1 \
           " --query \047Subnets[].{SubnetId:SubnetId,CidrBlock:CidrBlock,AvailabilityZone:AvailabilityZone }\047 " \
           " --output text"}' | sh
ap-northeast-1a	172.31.32.0/20	subnet-bf9488f6
ap-northeast-1c	172.31.0.0/20	subnet-78bff123
ap-northeast-1d	172.31.16.0/20	subnet-d96e89f2
ap-northeast-2a	172.31.0.0/20	subnet-fab6a392
ap-northeast-2c	172.31.16.0/20	subnet-a73f47eb
ap-south-1a	172.31.16.0/20	subnet-56aaea3e
ap-south-1b	172.31.0.0/20	subnet-47bc0d0b
ap-southeast-1b	172.31.16.0/20	subnet-defbf3b9
ap-southeast-1c	172.31.0.0/20	subnet-3ee12667
ap-southeast-1a	172.31.32.0/20	subnet-b94c74f0
ap-southeast-2c	172.31.16.0/20	subnet-c26dc19a
ap-southeast-2b	172.31.32.0/20	subnet-818da2c8
ap-southeast-2a	172.31.0.0/20	subnet-ea714c8d
ca-central-1a	172.31.16.0/20	subnet-0ffa7367
ca-central-1b	172.31.0.0/20	subnet-ae5d87d4
eu-central-1b	172.31.32.0/20	subnet-b79fdcca
eu-central-1c	172.31.0.0/20	subnet-c76c3a8a
eu-central-1a	172.31.16.0/20	subnet-72071319
eu-north-1b	172.31.32.0/20	subnet-940210ec
eu-north-1c	172.31.0.0/20	subnet-cf94a985
eu-north-1a	172.31.16.0/20	subnet-1392617a
eu-west-1c	172.31.0.0/20	subnet-c39e0ea5
eu-west-1b	172.31.32.0/20	subnet-8c06d4d6
eu-west-1a	172.31.16.0/20	subnet-aaf797e2
eu-west-2c	172.31.0.0/20	subnet-098f1660
eu-west-2a	172.31.16.0/20	subnet-09c96c73
eu-west-2b	172.31.32.0/20	subnet-5935dd15
eu-west-3b	172.31.16.0/20	subnet-0aa73671
eu-west-3c	172.31.32.0/20	subnet-45fa2008
eu-west-3a	172.31.0.0/20	subnet-ac631dc5
sa-east-1a	172.31.0.0/20	subnet-c7e114a1
sa-east-1c	172.31.16.0/20	subnet-c15aaa9a
us-east-1a	172.31.16.0/20	subnet-d57f299f
us-east-1f	172.31.64.0/20	subnet-a47109ab
us-east-1b	172.31.32.0/20	subnet-999b18c5
us-east-1c	172.31.0.0/20	subnet-9bf274fc
us-east-1e	172.31.48.0/20	subnet-da05cfe4
us-east-1d	172.31.80.0/20	subnet-07870a29
us-east-2a	172.31.0.0/20	subnet-fcaf8b94
us-east-2c	172.31.32.0/20	subnet-d9f13495
us-east-2b	172.31.16.0/20	subnet-8e3caef4
us-west-1b	172.31.16.0/20	subnet-73d8c914
us-west-1a	172.31.0.0/20	subnet-ea331eb1
us-west-2c	172.31.0.0/20	subnet-a41538fe
us-west-2b	172.31.16.0/20	subnet-2725775e
us-west-2a	172.31.32.0/20	subnet-f388f4b8

■スポット価格と比較出来るように価格の安い順に一覧する、全AZ毎にフィルタ。

$ aws ec2 describe-regions --query 'Regions[].{Name:RegionName}' --output text | sort -k 1 | \
    awk '{print "aws ec2 describe-availability-zones --query \047AvailabilityZones[].{Name:ZoneName}\047 --region "$1 \
                " --output text"}' | sh | \
      awk '{print "  aws ec2 describe-spot-price-history" \
                "  --availability-zone "$1 \
                "  --start-time $(date -d \0471 days ago\047 -u \047+%Y-%m-%dT%H:%M:%S.000Z\047)" \
                "  --product-description \042Linux/UNIX\042" \
                "  --instance-types t3.small t3.micro t3.nano" \
                "  --query \047SpotPriceHistory[].{InstanceType:InstanceType," \
                "ProductDescription:ProductDescription,AvailabilityZone:AvailabilityZone,SpotPrice:SpotPrice}\047" \
                "  --output text"}' | sh 2>/dev/null
us-west-1a	t3.nano	Linux/UNIX	0.001900
us-west-1a	t3.nano	Linux/UNIX	0.001900
us-west-1a	t3.small	Linux/UNIX	0.007700
us-west-1a	t3.small	Linux/UNIX	0.007700
us-west-1a	t3.micro	Linux/UNIX	0.003700
us-west-1a	t3.small	Linux/UNIX	0.007800
us-west-1a	t3.micro	Linux/UNIX	0.003700
us-west-1a	t3.nano	Linux/UNIX	0.001900
us-west-1a	t3.small	Linux/UNIX	0.007900
us-west-1b	t3.nano	Linux/UNIX	0.001900
us-west-1b	t3.nano	Linux/UNIX	0.001900
us-west-1b	t3.small	Linux/UNIX	0.007500
us-west-1b	t3.micro	Linux/UNIX	0.003700
us-west-1b	t3.micro	Linux/UNIX	0.003700
us-west-1b	t3.small	Linux/UNIX	0.007500
us-west-1b	t3.nano	Linux/UNIX	0.001900

■nano、microは過去3日および2018/09/18で同じため、価格変動はほぼない様子。
 t3.smallが多少増減している様子。

$ aws ec2 describe-spot-price-history \
    --start-time $(date -d '3 days ago' -u '+%Y-%m-%dT%H:%M:%S.000Z') \
    --product-description "Linux/UNIX" \
    --instance-types t3.small t3.micro t3.nano \
    --query 'SpotPriceHistory[].{InstanceType:InstanceType,ProductDescription:ProductDescription,AvailabilityZone:AvailabilityZone,SpotPrice:SpotPrice}' \
    --output text | awk '{a[$0]+=1}END{for(n in a){print a[n],n}}' | sort -k 4
5 us-west-1a	t3.nano	Linux/UNIX	0.001900
5 us-west-1b	t3.nano	Linux/UNIX	0.001900
4 us-west-1a	t3.micro	Linux/UNIX	0.003700
4 us-west-1b	t3.micro	Linux/UNIX	0.003700
4 us-west-1b	t3.small	Linux/UNIX	0.007500
2 us-west-1a	t3.small	Linux/UNIX	0.007700
1 us-west-1a	t3.small	Linux/UNIX	0.007800
1 us-west-1a	t3.small	Linux/UNIX	0.007900
1 us-west-1a	t3.small	Linux/UNIX	0.008000
1 us-west-1a	t3.small	Linux/UNIX	0.008100

■vpcイメージのAMI検索
 「block-device-mapping.volume-type=standard」で絞るとかなりレスポンスが速くなる。
 grepで2018年か,2019年に限定している。

$ time aws ec2 describe-images \
    --filters "Name=block-device-mapping.volume-type,Values=standard" \
              "Name=name,Values=*vpc*" \
    --query 'Images[].[Name, ImageId, OwnerId]' --output text | grep 201[89]\.
amzn-ami-vpc-nat-hvm-2017.09.1-testlongids.20180307-x86_64-ebs	ami-042f8760634b93f20	137112412989
amzn-ami-vpc-nat-hvm-2018.03.0.20181116-x86_64-ebs	ami-097ad469381034fa2	137112412989
amzn-ami-vpc-nat-hvm-2018.03.0.20180811-x86_64-ebs	ami-0d4027d2cdbca669d	137112412989
amzn-ami-vpc-nat-hvm-2018.03.0.20180508-x86_64-ebs	ami-1a0e107a	137112412989
amzn-ami-vpc-nat-hvm-2017.09.1.20180115-x86_64-ebs	ami-394e4c59	137112412989
amzn-ami-vpc-nat-hvm-2017.09.1.20180108-x86_64-ebs	ami-4fefef2f	137112412989
amzn-ami-vpc-nat-hvm-2018.03.0.20180622-x86_64-ebs	ami-8c8761ef	137112412989
amzn-ami-vpc-nat-hvm-2018.03.0.20180412-x86_64-ebs	ami-c1e1f2a1	137112412989
amzn-ami-vpc-nat-hvm-2017.09.1.20180103-x86_64-ebs	ami-c59495a5	137112412989
amzn-ami-vpc-nat-hvm-2017.09.1.20180307-x86_64-ebs	ami-da5441ba	137112412989

real	0m2.733s
user	0m0.568s
sys	0m0.060s

■microsoftのAMI検索

$ time aws ec2 describe-images --owners="microsoft" --query 'Images[].[Name, ImageId, OwnerId]' --output text
Windows_Server-2008-R2-SP1-English-64Bit-WebMatrix_Development-2012.06.12	ami-99c892dc	461346954234
Windows_Server-2008-R2-SP1-English-64Bit-WebMatrix_Hosting-2012.06.12	ami-9bc892de	461346954234
Windows_Server-2008-R2-SP1-English-64Bit-SQL_2008_R2_SP1_Standard-2012.06.12	ami-9bf1abde	461346954234
Windows_Server-2008-R2-SP1-English-64Bit-Windows_Media_Services_4.1-2012.06.12	ami-a3c892e6	461346954234

real	0m1.228s
user	0m0.568s
sys	0m0.072s

■debian-stretchのAMI検索

$ time aws ec2 describe-images \
    --filters "Name=name,Values=debian-stretch*" \
    --query 'Images[].[Name, ImageId, OwnerId]' \
    --output text | grep 201[89]-
debian-stretch-hvm-x86_64-gp2-2018-08-20-85640	ami-00b2578f8d3753164	379101102735
debian-stretch-hvm-x86_64-gp2-2018-08-14-82175	ami-0636bbe89b7d64bc6	379101102735
debian-stretch-hvm-x86_64-gp2-2018-11-10-63975-572488bb-fc09-4638-8628-e1e1d26436f4-ami-0f4768a55eaaac3d7.4	ami-09136521b9fd9a420	679593333241
debian-stretch-hvm-x86_64-gp2-2019-01-22-59357	ami-0d6c332a2e4be8050	379101102735
debian-stretch-hvm-x86_64-gp2-2018-11-10-63975	ami-0ebddb8af2428fc2e	379101102735
debian-stretch-hvm-x86_64-gp2-2018-10-01-66564	ami-0f0674cb683fcc1f7	379101102735
debian-stretch-hvm-x86_64-gp2-2019-01-14-59254	ami-0fdc435b23998a98b	379101102735
debian-stretch-hvm-x86_64-gp2-2018-07-15-72527	ami-1a9d7f79	379101102735
debian-stretch-hvm-x86_64-gp2-2018-01-06-16218	ami-6d03030d	379101102735
debian-stretch-hvm-x86_64-gp2-2018-03-11-19642	ami-76e3f616	379101102735
debian-stretch-hvm-x86_64-gp2-2018-02-22-67467	ami-8c828aec	379101102735
debian-stretch-hvm-x86_64-gp2-2018-06-13-59294	ami-a126c2c2	379101102735
debian-stretch-hvm-x86_64-gp2-2018-08-07-16934	ami-ad1df2ce	379101102735
debian-stretch-hvm-x86_64-gp2-2018-05-01-84002	ami-c55e41a5	379101102735
debian-stretch-hvm-x86_64-gp2-2018-04-09-292	ami-d6a5b5b6	379101102735
debian-stretch-hvm-x86_64-gp2-2018-05-14-16107	ami-da6178ba	379101102735

real	0m2.196s
user	0m0.604s
sys	0m0.032s

$ time aws ec2 describe-images \
    --filters "Name=owner-id,Values=379101102735" \
    --query 'Images[].[Name, ImageId]' --output text | grep stretch
debian-stretch-hvm-x86_64-gp2-2018-08-20-85640	ami-00b2578f8d3753164
debian-stretch-hvm-x86_64-gp2-2018-08-14-82175	ami-0636bbe89b7d64bc6
debian-stretch-hvm-x86_64-gp2-2019-01-22-59357	ami-0d6c332a2e4be8050
debian-stretch-hvm-x86_64-gp2-2018-11-10-63975	ami-0ebddb8af2428fc2e
debian-stretch-hvm-x86_64-gp2-2018-10-01-66564	ami-0f0674cb683fcc1f7
debian-stretch-hvm-x86_64-gp2-2019-01-14-59254	ami-0fdc435b23998a98b
debian-stretch-hvm-x86_64-gp2-2018-07-15-72527	ami-1a9d7f79
debian-stretch-amd64-hvm-2016-09-23-08-48-ebs	ami-25317f45
debian-stretch-hvm-x86_64-gp2-2017-08-31-64407	ami-560c3836
debian-stretch-hvm-x86_64-gp2-2017-10-08-48016	ami-58eedd38
debian-stretch-hvm-x86_64-gp2-2017-12-17-65723	ami-5d55523d
debian-stretch-hvm-x86_64-gp2-2018-01-06-16218	ami-6d03030d
debian-stretch-hvm-x86_64-gp2-2018-03-11-19642	ami-76e3f616
debian-stretch-hvm-x86_64-gp2-2017-07-22-75922	ami-7df8d11d
debian-stretch-hvm-x86_64-gp2-2018-02-22-67467	ami-8c828aec
debian-stretch-hvm-x86_64-gp2-2018-06-13-59294	ami-a126c2c2
debian-stretch-hvm-x86_64-gp2-2017-12-24-71024	ami-aa1610ca
debian-stretch-hvm-x86_64-gp2-2018-08-07-16934	ami-ad1df2ce
debian-stretch-hvm-x86_64-gp2-2018-05-01-84002	ami-c55e41a5
debian-stretch-hvm-x86_64-gp2-2017-06-21-52542	ami-c8a68ba8
debian-stretch-hvm-x86_64-gp2-2017-04-20-82073	ami-ce3115ae
debian-stretch-hvm-x86_64-gp2-2018-04-09-292	ami-d6a5b5b6
debian-stretch-hvm-x86_64-gp2-2018-05-14-16107	ami-da6178ba

real	0m2.413s
user	0m0.564s
sys	0m0.044s

■まとめると、owner-idのフィルタと、
 作成日時のフォーマットをちょっといじってあげればそれなりのリストになる。

$ time aws ec2 describe-images      --filters "Name=owner-id,Values=379101102735,461346954234,137112412989"                "Name=name,Values=*amzn*,*vpc*,debian-stretch*,*Windows*"      --query 'sort_by(Images[].{YMD:CreationDate,Name:Name,ImageId:ImageId,OwnerId:OwnerId},&YMD)|reverse(@)'      --output text | awk '(length($1)>20 && $NF ~ /2019-/)||$2 ~ /Windows/{gsub("T|.000Z"," ",$NF);print $0}'
ami-0d6c332a2e4be8050 debian-stretch-hvm-x86_64-gp2-2019-01-22-59357 379101102735 2019-01-22 18:44:28 
ami-0fdc435b23998a98b debian-stretch-hvm-x86_64-gp2-2019-01-14-59254 379101102735 2019-01-14 22:10:56 
ami-02b54bf0d4dd14e8e amzn2-ami-minimal-hvm-2.0.20190115-x86_64-ebs 137112412989 2019-01-14 19:24:01 
ami-0799ad445b5727125 amzn2-ami-hvm-2.0.20190115-x86_64-gp2 137112412989 2019-01-14 19:17:26 
ami-04934beceb260ec14 amzn2-ami-hvm-2.0.20190115-x86_64-ebs 137112412989 2019-01-14 19:13:18 
ami-0c5a40795c61e282d amzn2-ami-minimal-hvm-2.0.20190110-x86_64-ebs 137112412989 2019-01-08 06:53:59 
ami-0a16c82eb0cc3aad8 amzn2-ami-hvm-2.0.20190110-x86_64-gp2 137112412989 2019-01-08 06:47:17 
ami-0d480e8664c70e3d6 amzn2-ami-hvm-2.0.20190110-x86_64-ebs 137112412989 2019-01-08 06:44:10 
ami-9bf1abde Windows_Server-2008-R2-SP1-English-64Bit-SQL_2008_R2_SP1_Standard-2012.06.12 461346954234 2012-06-15 17:26:19 
ami-a3c892e6 Windows_Server-2008-R2-SP1-English-64Bit-Windows_Media_Services_4.1-2012.06.12 461346954234 2012-06-12 22:43:56 
ami-9bc892de Windows_Server-2008-R2-SP1-English-64Bit-WebMatrix_Hosting-2012.06.12 461346954234 2012-06-12 22:43:03 
ami-99c892dc Windows_Server-2008-R2-SP1-English-64Bit-WebMatrix_Development-2012.06.12 461346954234 2012-06-12 22:42:45 

real	0m9.550s
user	0m0.824s
sys	0m0.112s

■10秒程度なら待てそうなので、amazon+microsoftの一覧も。

$ time aws ec2 describe-images --owners amazon \
    --filters "Name=name,Values=Windows*201*Japan*" \
    --query 'sort_by(Images[].{YMD:CreationDate,Name:Name,ImageId:ImageId,OwnerId:OwnerId},&YMD)|reverse(@)' \
    --output text | awk '(length($1)>20 && $NF ~ /2019-/)&&$2 ~ /Windows/{gsub("T|.000Z"," ",$NF);print $0}'
ami-02e00d3f2329727cd Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2019.02.13 801119661308 2019-02-13 19:56:11 
ami-0612311692d26d84e Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Web-2019.02.13 801119661308 2019-02-13 14:03:21 
ami-0296843d5425acee4 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Enterprise-2019.02.13 801119661308 2019-02-13 12:16:36 
ami-092c412eac5ae59a6 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP3_Express-2019.02.13 801119661308 2019-02-13 11:43:45 
ami-09987a9982148e5a4 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Web-2019.02.13 801119661308 2019-02-13 10:23:11 
ami-0edbc289c26173619 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Standard-2019.02.13 801119661308 2019-02-13 10:23:06 
ami-0c39fedb167d029b0 Windows_Server-2012-R2_RTM-Japanese-64Bit-Base-2019.02.13 801119661308 2019-02-13 10:18:15 
ami-08cb0992584376830 Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Web-2019.02.13 801119661308 2019-02-13 09:54:55 
ami-0bf72651ae3f804ff Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Standard-2019.02.13 801119661308 2019-02-13 09:54:48 
ami-0c39cb6e5425ffb06 Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Express-2019.02.13 801119661308 2019-02-13 09:54:42 
ami-089f6819226a2a53a Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Enterprise-2019.02.13 801119661308 2019-02-13 09:54:36 
ami-084f0892097d8f99d Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Web-2019.02.13 801119661308 2019-02-13 09:54:30 
ami-07444cbf26cf7719c Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Standard-2019.02.13 801119661308 2019-02-13 09:54:24 
ami-0a139b003a89d61ac Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Express-2019.02.13 801119661308 2019-02-13 09:54:16 
ami-0463855b465267c16 Windows_Server-2016-Japanese-Full-Base-2019.02.13 801119661308 2019-02-13 09:54:10 
ami-0f7600b6532d9da9a Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Standard-2019.02.13 801119661308 2019-02-13 09:43:17 
ami-0c5ae43f1867861d0 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Express-2019.02.13 801119661308 2019-02-13 09:43:10 
ami-0d8839b9e7141253c Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Enterprise-2019.02.13 801119661308 2019-02-13 09:43:03 
ami-0007bc1c96c926476 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Web-2019.02.13 801119661308 2019-02-13 09:42:56 
ami-0d8571a2363dfa8c4 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Standard-2019.02.13 801119661308 2019-02-13 09:42:50 
ami-04baae9c2d7438a2d Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Express-2019.02.13 801119661308 2019-02-13 09:42:43 
ami-0cc8462207cf00072 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Enterprise-2019.02.13 801119661308 2019-02-13 09:42:36 
ami-00c276524f02d87ff Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP3_Standard-2019.02.13 801119661308 2019-02-13 09:42:30 
ami-0ede0e523cda70e9b Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Express-2019.02.13 801119661308 2019-02-13 09:42:23 
ami-04f3846cda502d9fd Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Web-2019.02.13 801119661308 2019-02-13 09:11:33 
ami-077dd9f7fb837755b Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Standard-2019.02.13 801119661308 2019-02-13 09:11:26 
ami-0e5f4c4fa21c4807f Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Express-2019.02.13 801119661308 2019-02-13 09:11:20 
ami-00169ed356a848f4a Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Web-2019.02.13 801119661308 2019-02-13 09:11:14 
ami-06f325b9202c43cca Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2019.02.13 801119661308 2019-02-13 09:11:06 
ami-0421c8c3f4d6524d7 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Express-2019.02.13 801119661308 2019-02-13 09:10:55 
ami-063ccfda8a84f1514 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Express-2019.02.13 801119661308 2019-02-13 09:10:44 
ami-0cac07d4996d2a5f3 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Standard-2019.02.13 801119661308 2019-02-13 08:29:42 
ami-0477e8d7c53d5f9eb Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Express-2019.02.13 801119661308 2019-02-13 08:29:36 
ami-0048904c2595ed1c3 Windows_Server-2012-RTM-Japanese-64Bit-Base-2019.02.13 801119661308 2019-02-13 08:29:29 
ami-0b8dc5273648c8e76 Windows_Server-2019-Japanese-Full-Base-2019.02.13 801119661308 2019-02-13 08:03:23 
ami-0cf9e87281397877b Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Standard-2018.12.13 801119661308 2019-02-09 12:00:34 
ami-0bfa755bab1d01545 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Web-2018.12.13 801119661308 2019-02-09 11:03:22 
ami-05dfde831a3225d39 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Standard-2018.12.13 801119661308 2019-02-09 11:03:15 
ami-03b1cdfc88850f471 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Web-2018.12.13 801119661308 2019-02-09 11:02:47 
ami-05f772f57fb92289d Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2018.12.13 801119661308 2019-02-09 11:02:39 
ami-0f78aad419fd3769e Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Express-2018.12.13 801119661308 2019-02-09 11:02:33 
ami-0c1076d6d47ae4b25 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Web-2018.12.13 801119661308 2019-02-09 11:02:25 
ami-0b9f206f7c1338430 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Standard-2018.12.13 801119661308 2019-02-09 11:02:20 
ami-096fedc62246b7348 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Express-2018.12.13 801119661308 2019-02-09 11:02:12 
ami-02cf416421501c3a4 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Express-2018.12.13 801119661308 2019-02-09 11:02:04 
ami-0255949db7b205b4f Windows_Server-2012-RTM-Japanese-64Bit-Base-2018.12.13 801119661308 2019-02-09 11:01:58 
ami-0fbd9de3f80028a65 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Standard-2018.12.13 801119661308 2019-02-09 10:56:23 
ami-036649180e237518d Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Express-2018.12.13 801119661308 2019-02-09 10:56:16 
ami-056545290f16f9125 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Enterprise-2018.12.13 801119661308 2019-02-09 10:56:10 
ami-09072c4562e1bdcc4 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Standard-2018.12.13 801119661308 2019-02-09 10:55:54 
ami-06908b536ac0e262d Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Enterprise-2018.12.13 801119661308 2019-02-09 10:55:37 
ami-0e245ee9e1d3af10b Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP3_Standard-2018.12.13 801119661308 2019-02-09 10:55:30 
ami-0d644671e6691e73a Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP3_Express-2018.12.13 801119661308 2019-02-09 10:55:24 
ami-01cc7d381fb9cebb0 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2018.12.13 801119661308 2019-02-09 10:55:17 
ami-0da15102f201f5136 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Express-2018.12.13 801119661308 2019-02-09 10:55:11 
ami-05b64959aaf6544e4 Windows_Server-2012-R2_RTM-Japanese-64Bit-Base-2018.12.13 801119661308 2019-02-09 10:55:05 
ami-04bbfc54bb05f6eee Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Web-2018.11.29 801119661308 2019-02-09 05:32:34 
ami-0576c19f17c9ce726 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2018.11.29 801119661308 2019-02-09 05:32:29 
ami-0637a6ab45d44f8a3 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Express-2018.11.29 801119661308 2019-02-09 05:32:23 
ami-05a642333b63c7ae9 Windows_Server-2012-R2_RTM-Japanese-64Bit-Base-2018.11.29 801119661308 2019-02-09 04:43:31 
ami-01dd02b77710375f5 Windows_Server-2019-Japanese-Full-Base-2019.02.09 801119661308 2019-02-09 04:37:37 
ami-057c7be9bbe5b446c Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Express-2018.11.29 801119661308 2019-02-09 03:57:52 
ami-0eb2b3a8214fdeca7 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Web-2018.11.29 801119661308 2019-02-09 03:57:46 
ami-045d0d56795653e4a Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Standard-2018.11.29 801119661308 2019-02-09 03:57:40 
ami-0120dcaf9a28bc53c Windows_Server-2012-RTM-Japanese-64Bit-Base-2018.11.29 801119661308 2019-02-09 03:56:46 
ami-0deeb9b8d2c8827e8 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Web-2018.11.29 801119661308 2019-02-09 03:54:38 
ami-0d469dc08622b76cd Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Standard-2018.11.29 801119661308 2019-02-09 03:54:31 
ami-02ac79cc77dfb18cb Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Express-2018.11.29 801119661308 2019-02-09 03:54:25 
ami-026240680e726276b Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Enterprise-2018.11.29 801119661308 2019-02-09 03:54:18 
ami-0ee657259869d0035 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2018.11.29 801119661308 2019-02-09 03:54:11 
ami-08966538da1cfd4e2 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Express-2019.02.09 801119661308 2019-02-09 00:15:54 
ami-0afb1d8c594def41c Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Web-2019.02.09 801119661308 2019-02-08 23:43:24 
ami-0d9f8de6756a0e04a Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Standard-2019.02.09 801119661308 2019-02-08 23:43:19 
ami-0003711d008ac685a Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Express-2019.02.09 801119661308 2019-02-08 23:43:13 
ami-0358fb8593e5c2c77 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Express-2018.11.29 801119661308 2019-02-08 23:42:23 
ami-0b8ccb2df197da68f Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Standard-2018.11.29 801119661308 2019-02-08 23:42:17 
ami-035391b5a7e930c68 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Express-2019.02.09 801119661308 2019-02-08 23:42:01 
ami-035ba45e14ffb7c5a Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Express-2018.12.13 801119661308 2019-02-08 23:39:09 
ami-0d7d685743d764d71 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Web-2019.02.09 801119661308 2019-02-08 23:33:19 
ami-0b6a0e2c2c405ba40 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP3_Standard-2019.02.09 801119661308 2019-02-08 23:33:13 
ami-011fb54cd32cd8f99 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Web-2019.02.09 801119661308 2019-02-08 23:33:06 
ami-0ae123a7f7029a475 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Express-2019.02.09 801119661308 2019-02-08 23:32:36 
ami-0d8ce04e50e24aa9e Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Web-2019.02.09 801119661308 2019-02-08 23:32:29 
ami-07e213925ea2d6251 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Standard-2019.02.09 801119661308 2019-02-08 23:32:22 
ami-05f0a4f049811173c Windows_Server-2012-RTM-Japanese-64Bit-SQL_2012_SP4_Express-2019.02.09 801119661308 2019-02-08 23:32:16 
ami-0a38708791c1057af Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Express-2019.02.09 801119661308 2019-02-08 23:31:43 
ami-0d778a537b259911b Windows_Server-2012-RTM-Japanese-64Bit-Base-2019.02.09 801119661308 2019-02-08 23:31:37 
ami-06134c3630c863a4a Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Standard-2019.02.09 801119661308 2019-02-08 23:25:21 
ami-010b6887cbb263707 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Express-2019.02.09 801119661308 2019-02-08 23:25:14 
ami-02f01524f887874c5 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Enterprise-2019.02.09 801119661308 2019-02-08 23:25:09 
ami-0335d9d836cae7487 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Web-2019.02.09 801119661308 2019-02-08 23:25:03 
ami-056ab722ccbf59678 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Standard-2019.02.09 801119661308 2019-02-08 23:24:58 
ami-029fd6ef3f73a0d8c Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Express-2019.02.09 801119661308 2019-02-08 23:24:51 
ami-0fede383f39b68fa2 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP3_Standard-2019.02.09 801119661308 2019-02-08 23:24:19 
ami-07868e500e45fdaba Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP3_Express-2019.02.09 801119661308 2019-02-08 23:24:14 
ami-06c99da1acfb4e048 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2019.02.09 801119661308 2019-02-08 23:24:09 
ami-0dcc9b8cd7f5edae7 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Express-2019.02.09 801119661308 2019-02-08 23:24:04 
ami-05ab604827d5d5296 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Web-2018.12.13 801119661308 2019-02-08 23:23:46 
ami-0e27a82d8192996d6 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Web-2018.12.13 801119661308 2019-02-08 23:23:40 
ami-0e0d15a66f49ce643 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Express-2018.12.13 801119661308 2019-02-08 23:23:33 
ami-0e3ca718197babc1e Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2014_SP2_Express-2018.11.29 801119661308 2019-02-08 23:16:19 
ami-0a82d2d398ba08811 Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Enterprise-2019.02.09 801119661308 2019-02-08 22:59:48 
ami-04b57d4a0ca7d1c09 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Web-2019.02.09 801119661308 2019-02-08 22:59:43 
ami-07e764b3a127cd146 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Standard-2019.02.09 801119661308 2019-02-08 22:59:37 
ami-0ea315a27efff7b1d Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Enterprise-2019.02.09 801119661308 2019-02-08 22:59:29 
ami-0078d667c94eaf544 Windows_Server-2016-Japanese-Full-Base-2019.02.09 801119661308 2019-02-08 22:59:23 
ami-0225312b405dc66e5 Windows_Server-2012-RTM-Japanese-64Bit-SQL_2014_SP2_Standard-2019.02.09 801119661308 2019-02-08 22:54:56 
ami-0608f8d28f7fe7c2e Windows_Server-2012-RTM-Japanese-64Bit-SQL_2008_R2_SP3_Standard-2019.02.09 801119661308 2019-02-08 22:54:50 
ami-02fe42b588fbf17dd Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP2_Web-2019.02.09 801119661308 2019-02-08 22:52:24 
ami-0225dc492065432b9 Windows_Server-2012-R2_RTM-Japanese-64Bit-SQL_2016_SP1_Enterprise-2019.02.09 801119661308 2019-02-08 22:52:15 
ami-0e01f589a202be11b Windows_Server-2012-R2_RTM-Japanese-64Bit-Base-2019.02.09 801119661308 2019-02-08 22:52:04 
ami-0a96b5a7922879209 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Web-2018.11.29 801119661308 2019-02-08 22:11:53 
ami-081f2fa5c962b26c3 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Standard-2018.11.29 801119661308 2019-02-08 22:11:47 
ami-063cc92485072d8f8 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Express-2018.11.29 801119661308 2019-02-08 22:11:41 
ami-065dbf37d77c50470 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Enterprise-2018.11.29 801119661308 2019-02-08 22:11:35 
ami-0e45272e02276221e Windows_Server-2016-Japanese-Full-Base-2018.11.29 801119661308 2019-02-08 18:35:46 
ami-0ff0a16a2ce9ee1d5 Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Web-2018.12.13 801119661308 2019-02-08 12:18:19 
ami-09c95ca1cf3cca98d Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Standard-2018.12.13 801119661308 2019-02-08 12:18:13 
ami-0146aabc4a0fd8494 Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Express-2018.12.13 801119661308 2019-02-08 12:18:06 
ami-0e00fbdfadecbdc2a Windows_Server-2016-Japanese-Full-SQL_2016_SP2_Enterprise-2018.12.13 801119661308 2019-02-08 12:18:00 
ami-0cc870f6f83d55f1c Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Enterprise-2018.12.13 801119661308 2019-02-08 12:16:44 
ami-0d371e92fbd515725 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Web-2018.12.13 801119661308 2019-02-08 11:37:59 
ami-04acd60bc723b3d30 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Standard-2018.12.13 801119661308 2019-02-08 11:37:53 
ami-0effff44be6e07c11 Windows_Server-2016-Japanese-Full-SQL_2016_SP1_Express-2018.12.13 801119661308 2019-02-08 11:37:46 
ami-091d1f7958c2af34d Windows_Server-2016-Japanese-Full-Base-2018.12.13 801119661308 2019-02-08 11:37:37 
ami-060f9bc56467435ee Windows_Server-2019-Japanese-Full-Base-2018.12.13 801119661308 2019-02-08 11:19:17 

real	0m9.034s
user	0m0.732s
sys	0m0.056s

■1年間の無料枠のWindowsサーバはリージョン「ap-northeast-1」を指定する必要がある点に注意する。
 なるほどー。これがリージョンサービスってやつか。

$ grep region .aws/config 
region = ap-northeast-1

$ echo -e 'ami-06fb037fb7258dee2\nami-04568cdbd4ceef482' | \
    awk '{print "aws ec2 describe-images --image-ids "$1" --query \047Images[].[Name, ImageId, OwnerId]\047 --output text"}' | sh
Windows_Server-2019-English-Full-ContainersLatest-2019.02.09	ami-06fb037fb7258dee2	801119661308
Windows_Server-2019-English-Full-Base-2019.02.09	ami-04568cdbd4ceef482	801119661308

■起動ステータスの確認

$ aws ec2 describe-instance-status --output text | sed -e 's/\ti-.*/\ti-XXXXXXXXXXXXXXXXX/'
INSTANCESTATUSES	ap-northeast-1a	i-XXXXXXXXXXXXXXXXX
INSTANCESTATE	16	running
INSTANCESTATUS	ok
DETAILS	reachability	passed
SYSTEMSTATUS	ok
DETAILS	reachability	passed

■セキュリティグループやVPCはAWSコンソールウィザードから自動的に作成されたものなので、
 入力方向の0.0.0.0/0からのTCP/3389通信が許可されている。
 ルーティングテーブルでlocalと定義されているVPCサブネット「172.31.0.0/16」を
 更にAZ毎(/20)で区切ったサブネットの内、ap-northeast-1aで稼働中の
 プライベートIPに、グローバルIPアドレスが割り当てられていることが分かる。

$ aws ec2 describe-instances --query 'Reservations[].Instances[].SecurityGroups' --output text | \
    sed -e 's/sg-................./sg-XXXXXXXXXXXXXXXXX/'
sg-XXXXXXXXXXXXXXXXX	launch-wizard-1

$ aws ec2 describe-security-groups --group-name launch-wizard-1 --query 'SecurityGroups[].IpPermissions' --output text
3389	tcp	3389
IPRANGES	0.0.0.0/0

$ aws ec2 describe-route-tables --query 'RouteTables[].Routes' --output text
172.31.0.0/16	local	CreateRouteTable	active
0.0.0.0/0	igw-41bfe125	CreateRoute	active

$ aws ec2 describe-vpcs --query Vpcs[].[CidrBlock,IsDefault,InstanceTenancy] --output text
172.31.0.0/16	True	default

$ aws ec2 describe-subnets --filter 'Name=availabilityZone,Values=ap-northeast-1a' --query 'Subnets[].CidrBlock' --output text
172.31.32.0/20

$ aws ec2 describe-network-interfaces \
    --query 'NetworkInterfaces[].PrivateIpAddresses[].[Association.PublicIp,PrivateIpAddress]' \
    --output text | sed -e 's/\([0-9]*\.[0-9]*\.\)[0-9]*\.[0-9]*/\1X.X/g'
13.112.X.X	172.31.X.X

■その他、費用というかスペックに関連する種別情報

$ aws ec2 describe-instances \
    --query 'Reservations[].Instances[].[VirtualizationType,RootDeviceName,RootDeviceType,Platform,Architecture,InstanceType]' \
    --output text
hvm	/dev/sda1	ebs	windows	x86_64	t2.micro