iapilgrim

Thanks. Here is my modification to find Ubuntu 16.04
```

for region in us-east-1 us-east-2 us-west-1 us-west-2 eu-west-1 eu-west-2 eu-central-1 ap-northeast-1 ap-southeast-1 ap-southeast-2 ca-central-1
do
ami=aws --region $region ec2 describe-images \ --filters Name=root-device-type,Values=ebs \ Name=architecture,Values=x86_64 \ Name=virtualization-type,Values=hvm \ Name=name,Values=*ubuntu-xenial-16.04-amd64-server-20161214 \ --query 'Images[*].{ID:ImageId}' --output text

echo $region, $ami

done

Thank you. It does help for my Flask app.

Thanks

Thank for sharing.
I've got following error

column ts.spclocation does not exist
LINE 7: COALESCE(TS.spclocation, XS.spclocation, '') AS "locatio..