I am trying to query instances in my account by this info but I Need to also add owner email and can't seem to figure it out.
aws ec2 describe-instances \
--query "Reservations[*].Instances[*].{PublicIP:PublicIpAddress,Type:InstanceType,Name:Tags[?Key=='Name']|[0].Value,Status:State.Name}" \
--filters "Name=instance-state-name,Values=*" "Name=tag:Name,Values='*'" \
--output table
Any help is appreciated!