Get List of EC2 instances from All regions

ec2.sh

# install aws cli first and configure it with credentials and default region
# the script will iterate over all regions of AWS

for region in `aws ec2 describe-regions --output text | cut -f4`
do
     echo -e "\nListing Instances in region:'$region'..."
     aws ec2 describe-instances --query "Reservations[*].Instances[*].{IP:PublicIpAddress,ID:InstanceId,Type:InstanceType,State:State.Name,Name:Tags[0].Value}" --output=table --region $region
done

It works as expected, but i had to execute first "aws configure" with empty values on everything except the region, because if you do not have any default region, the CLI complaints it does not know in which region work even when executing "aws ec2 describe-regions" alone.
I also tried to pass as argument --region eu-west-1 but it does not work, you have to do the aws configure thing first to stablish a default region.

@dgacias just export values before the loop

export AWS_PROFILE=<YOUR-PROFILE>
export AWS_DEFAULT_REGION=<SOME-REGION>

you're d man !

FYI, you need to change the "cut -f3" to "cut -f4" now as AWS added another field to the describe-regions output.

@jake9696
Thanks for pointing it out.
I have updated it.

If you don't have the defaults set cut f3 works, if you do use cut f4

its works thanks

aws ec2 describe-regions --output text --query 'Regions[].RegionName'

Name:Tags[0].Value > Name:Tags[?Key=='Name']|[0].Value

The first tag may be different.

Hi Everyone,
How to export that output to excel format?