AWS EC2 リザーブドインスタンスの購入検討に役立ちそうなワンライナー（途中） ref: http://qiita.com/iktakahiro/items/4c9cd0452a7edea6d9b0

file0.txt

$ aws ec2 describe-instances | jq -r '.Reservations[].Instances[] | select(.State.Name == "running") | [.InstanceId, .InstanceType, .Placement.AvailabilityZone, .Tags[].Value] |@csv '

file1.txt

"i-aaaaaaaa","t2.medium","ap-northeast-1b","Tag1","Tag2"
"i-bbbbbbbb","r3.large","ap-northeast-1b","Tag1","Tag2"
"i-cccccccc","m1.small","ap-northeast-1c","Tag1","Tag2"
"i-dddddddd","t2.small","ap-northeast-1b","Tag1","Tag2"
"i-eeeeeeee","m1.small","ap-northeast-1b","Tag1","Tag2"

file2.txt

$ aws ec2 describe-reserved-instances |jq -r '.ReservedInstances[] | select(.State == "active") | [.InstanceType, .AvailabilityZone, .OfferingType, .InstanceCount] | @csv'

file3.txt

"m3.large","ap-northeast-1c","No Upfront",1
"c3.2xlarge","ap-northeast-1c","No Upfront",1
"c3.large","ap-northeast-1c","Partial Upfront",1
"t2.medium","ap-northeast-1c","No Upfront",1
"m3.medium","ap-northeast-1c","No Upfront",1
"m3.large","ap-northeast-1c","Partial Upfront",1