aws-ec2-summary.sh

#!/bin/bash
(
  echo "InstanceId,Name,Status,PublicIP,PrivateIP,InstanceType,AvailabilityZone,LaunchTime"
  aws ec2 describe-instances | \
    jq -r '.[][].Instances[] | [.InstanceId,
                                [.Tags[] | select(.Key == "Name").Value][],
                                .State.Name, .PublicIpAddress,
                                .PrivateIpAddress,
                                .InstanceType,
                                .Placement.AvailabilityZone,
                                .LaunchTime] |@csv' | \
    sed -e 's/,,/,-,/g' -e 's/"//g'
) | column -s, -t