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

@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?