AWS - Retreive All EC2 Instances w/ Info

aws_instances.sh

#!/bin/bash
# AWS CLI to return all EC2 Data

#install AWS CLI 
pip install awscli --upgrade --user

#Uncomment below to setup AWS IAM Keys
#aws configure

#Below command puts all instance details intto a .tsv which can be imorted to Excel as a csv with columns and rows
#Change key name to any other custom keys you want to output
aws ec2 describe-instances --output text --query 'Reservations[*].Instances[*].[InstanceId, InstanceType, ImageId, State.Name, LaunchTime, Placement.AvailabilityZone, Placement.Tenancy, PrivateIpAddress, PrivateDnsName, PublicDnsName, [Tags[?Key==`Name`].Value] [0][0], [Tags[?Key==`purpose`].Value] [0][0], [Tags[?Key==`environment`].Value] [0][0], [Tags[?Key==`name`].Value] [0][0] ]' > ec2_instances.tsv