Dump AWS EC2 instances to tab delimited output

ec2-instance-dumper.sh

#!/bin/bash

echo -e "Name\tInstanceID\tInstanceType\tState\tLaunchTime\tAvailabilityZone\tPrivateIP\tPublicIP"

#aws ec2 describe-instances --output text --query 'Reservations[*].Instances[*].[[Tags[?Key==`Name`].Value] [0][0], InstanceId, InstanceType, State.Name, LaunchTime, Placement.AvailabilityZone, PrivateIpAddress, PublicIpAddress ]'
aws ec2 describe-instances > instances.json

cat instances.json | jq -r '.Reservations[].Instances[]| [(.Tags[] | select(.Key == "Name") | .Value), .InstanceId, .InstanceType, .State.Name, .LaunchTime, .Placement.AvailabilityZone, .PrivateIpAddress, .PublicIpAddress, .VpcId ] | @tsv'